Do you use a script for the calculation, or some other means?
I use a simplified field notation:
(Text27/Text124) + 1
Since you're dividing by the value of a field you should use a custom calculation anyway, and it will also allow you to round the result.
Use this code instead:
var v1 = Number(this.getField("Text27").valueAsString); var v2 = Number(this.getField("Text124").valueAsString); if (v2==0) event.value = ""; else event.value = Math.ceil((v1/v2) + 1);
Ok that is really close!
For some reason, it rounds up to one more number than needed. For example, 7.63 rounds to 9.00 instead of 8 and 3.81 rounds up to 5.00 instead of 4. Any ideas on why?
Thanks for all your help!
Nevermind, I was running the formula wrong. That should work! Thank you!!