PCForm
01-05-2019
Hello,
I've tried both Form Calc and JavaScript and my calculation is still wrong.
=(Cell5.rawValue*Subform2.RecLimit.rawValue)/100;
63% * $12,000,000 / 100 = 7,560,000
My total keeps coming out to 7,500,000. What am I doing wrong?
_Bruce_Robertson
MVP
20-08-2019
Maybe try
(parseFloat(Cell5.rawValue)*Subform2.RecLimit.rawValue)/100;
The parseFloat() function will get the "%" out of the way