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
Establish
MVP
_Bruce_Robertson
MVP

Likes

271 likes

Total Posts

1,782 posts

Correct reply

372 solutions
Top badges earned
Establish
Give Back 25
Give Back 10
Give Back 5
Give Back 3
View profile

Avatar
Establish
MVP
_Bruce_Robertson
MVP

Likes

271 likes

Total Posts

1,782 posts

Correct reply

372 solutions
Top badges earned
Establish
Give Back 25
Give Back 10
Give Back 5
Give Back 3
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