Expand my Community achievements bar.

Repeatable Subform Calculation

Avatar

Level 2

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?

Doc2.jpg

1 Reply

Avatar

Level 10

Maybe try

(parseFloat(Cell5.rawValue)*Subform2.RecLimit.rawValue)/100;

The parseFloat() function will get the "%" out of the way