Error Arithmetic overflow

[webnetworksmd]

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.

[radzmar]

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