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

Avatar

Avatar
Validate 1
Level 1
PCForm
Level 1

Likes

0 likes

Total Posts

17 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
PCForm
Level 1

Likes

0 likes

Total Posts

17 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile
PCForm
Level 1

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?

Doc2.jpg

Accepted Solutions (0)

Answers (1)

Answers (1)

Avatar

Avatar
Boost 50
MVP
_Bruce_Robertson
MVP

Likes

269 likes

Total Posts

1,782 posts

Correct Reply

372 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 250
Boost 25
View profile

Avatar
Boost 50
MVP
_Bruce_Robertson
MVP

Likes

269 likes

Total Posts

1,782 posts

Correct Reply

372 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 250
Boost 25
View profile
_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