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!