This content has been marked as final.
Show 2 replies
-
1. Re: Percentage per row
Kenneth McBride Jul 13, 2016 2:16 PM (in response to Maddy Pena)1 of 1 people found this helpfulMaddy,
You need to edit your calculated field for Turnover % and wrap each of the two metrics (headcount and turnover count) in a SUM(). So this:
SUM([Turnover Count])/SUM([Headcount])*100
The issue is the way you currently have it calculated it does Turnover Count / Headcount for every single row and then sums the answers which is producing some nulls because some of your rows have nulls for one or both of those fields. By moving the addition, SUM(), inside your calculated field you will be adding up all the turnover counts and all the headcounts and then dividing those two numbers.
Your calculation is a row level calculation and it needs to be an aggregated calculation. Let me know if that works for you.
Ken
-