Copy link to clipboard
Copied
On the attached form there is some wierd rounding issues occuring that I can't figure out.
Line 7 and 8 are both numbers to two decimal places.
Line 9 uses the following formula:
var a = this.getField("A").value;
var b = this.getField("B").value;
if (a !=="" || b !==""){
event.value = b-a;
} else {
event.value ="";
}
value of a is 5,112,068.82
value of b is 5,184,600.47
For some reason line 9 calculates to 72531.64999999944.
I am having the same issues with line 10.
Can someone please take a look and help me out? I attached the PDF for reference.
Copy link to clipboard
Copied