Expand my Community achievements bar.

Dive into Adobe Summit 2024! Explore curated list of AEM sessions & labs, register, connect with experts, ask questions, engage, and share insights. Don't miss the excitement.

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