I'm trying to creating a form where there will be 3 fields. two numeric fields and a third numeric field where I'd like to show the total percentage ex: field A 70 / field B 100 *100 = Field C (Total Percentage) but I keep getting a arithmetic underflow error. Need some help
I thought it would be something like:
but I keep getting the arithmetic underflow error. The formula actually works but I'm trying to get rid of that error.
I did not set any default values to Field1 and Field2 - they are just user entered fields and will appear blank on your form. In order to avoid dividing by zero, you have to first determine if there are values in Field1 and Field2. In my example, if either Field1 or Field2 is blank, I set the value of Field3 to 0 (using an "If, elseif, then" statement). Only when there are 2 values will the division operation occur.
The code is formcalc, entered in the calculate event of Field3.
Thank you so much lateniteNC. I was stumped on why the formula wouldn't work and I did a little more digging and I found a script that was written in the ALL EVENT script editor that was giving me the error codes. I removed the script and everything is working perfectly.