Calculated field not giving right answer

I have a tota amount and a total headcount, created a simple division as a calculated field but it is giving a wrong amount. It is suppose to divide the 1st two columns but instead giving me a wrong CPH.


you need to sum up the values in your calculation.

sum(a) / sum(b)

When you just use a/b, the table will aggregate on this, so you then have sum(a/b).

Lets say, you have two values in each column, then the first method would give you this result:

sum(5+10)/sum(1+2) = 5

The second method, without the sums would give you this result:

sum(5/1 + 10/2) = 10


thank you! that worked!

1 Like