Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Error Arithmetic overflow

Avatar

Level 1

I have multiple number fields that perform calculations based on GPA, Credits, Quality Points etc.. the last two fields divide previous returned values but when the form opens I get the overflow error.

How do you surround the calculation with a check to assure the variables are non zero, non-null?

How can you prevent the fields from trying to calculate until the form is loaded?

Any help is greatly appreciated.

1 Reply

Avatar

Level 10

Hi,

You should wrap your formula into an if expression.

FormCalc will always create under/overflows when you try to multiply or devide by 0.

if (fieldA ne 0 and fieldB ne 0) then

     ;add your formula here!

endif