Avatar

Correct answer by
Level 10

Hi,

When dividing, it is worth checking that the value of the field under the line is not null or zero first. So the calculate event of the hidden field would look something like this:

if (b.rawValue == null || b.rawValue == 0)

{

     c.rawValue = "0"; // If c is a numeric field. If it is a text field then you could put a message "division by zero"

}

else

{

     c.rawValue = a.rawValue / b.rawValue;

}

Hope that helps,

Niall

View solution in original post