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
BedrockMission!

Learn more

View all

Sign in to view all badges

Repeatable Subform Calculation

PCForm
Level 2
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
_Bruce_Robertson
Level 10
Level 10

Maybe try

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

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