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

Divide total (Table1 - Table2)

Nortel22
Level 2
Level 2

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!

1 Reply
MinusZero
Level 7
Level 7

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