Skip to Content
0
Former Member
May 27, 2008 at 06:33 PM

Divide by zero

19 Views

Post Author: skootsu

CA Forum: Formula

Can any one help me with a divide by zero error? I have two fields that should result in either a positive, negative or zero value.

Example, I have fields for:

@RGTime is {OPERATION.SETUP_HRS}+{OPERATION.RUN}

@RPTime is {OPERATION.ACT_SETUP_HRS}+{OPERATION.ACT_RUN_HRS}

All of these fields can contain either a 0 or a positive value. I need to get a Variance. I made my formula for

@Variance is {@RoutedTime}/{@RptdTime} I am getting the divide by zero error. Example date on a record is:

@RGTime=0.00 and @RPTime=0.02, thus @Variance should equal -0.02

How can I code for this?