Level 1
Level 2
Sign in to Community
Learn more
Sign in to view all badges
Expand my Community achievements bar.
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?
Maybe try
(parseFloat(Cell5.rawValue)*Subform2.RecLimit.rawValue)/100;
The parseFloat() function will get the "%" out of the way
Views
Likes
Replies