Divide total (Table1 - Table2)

Avatar

Avatar
Validate 1
Level 1
Nortel22
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
Nortel22
Level 1

Likes

0 likes

Total Posts

17 posts

Correct reply

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

07-02-2018

I need to divide the total from Tables1 - Table2.  I am using formcalc.  Right now in the calculate event I have

Table1.TotalOne / Table2.Total

Of course, that is not working.  Please help!

Accepted Solutions (0)

Answers (1)

Answers (1)

Avatar

Avatar
Validate 1
Level 4
MinusZero
Level 4

Likes

30 likes

Total Posts

326 posts

Correct reply

54 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 25
Boost 10
View profile

Avatar
Validate 1
Level 4
MinusZero
Level 4

Likes

30 likes

Total Posts

326 posts

Correct reply

54 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 25
Boost 10
View profile
MinusZero
Level 4

11-02-2018

Are you referencing your fields correctly. I dont know how your form looks, but if it is a table, shouldnt there be a row to reference?

eg in the calculate event:

Table1.Row1.TotalOne / Table2.Row1.Total