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?