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

Divide by zero


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:



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?