Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

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