
1. Re: Calculated %'s add up to 99%, 100% and 101%
Okechukwu Ossai May 15, 2018 12:20 PM (in response to s.sprague)1 of 1 people found this helpfulYour calculations are correct. The extra or deficit percentage is due to round up error. If you change the number format to percentage, 2 decimal places then you will see that the numbers all add up to 100%.
For example, Central Valley adds up correctly,
1.12 + 2,25 + 22.47 + 12.36 + 2.25 + 39.33 + 3.37 + 16.85 = 100%
Hope this helps.
Ossai

2. Re: Calculated %'s add up to 99%, 100% and 101%
s.sprague May 16, 2018 8:05 AM (in response to Okechukwu Ossai)It does help. One more question. I need the parentheses around the percentage which it doesn't appear I can configure in the Percentage option (but can with the Custom option). Any trick to using the Percentage option and include () around the resulting number?
Thanks so much.

3. Re: Calculated %'s add up to 99%, 100% and 101%
Okechukwu Ossai May 16, 2018 8:38 AM (in response to s.sprague) 
4. Re: Calculated %'s add up to 99%, 100% and 101%
s.sprague May 16, 2018 8:42 AM (in response to s.sprague)Additionally, is there a way I can only list the %s in Total Injuries Totals fields (end of tan lines on right side)? Not the total counts in the partition.
Thank you!

5. Re: Calculated %'s add up to 99%, 100% and 101%
Okechukwu Ossai May 16, 2018 8:53 AM (in response to s.sprague)Do you mean listing the individual Cause percentages in the Grand totals  Districts' worksheet?

6. Re: Calculated %'s add up to 99%, 100% and 101%
s.sprague May 16, 2018 10:02 AM (in response to Okechukwu Ossai)No, like in the Central Valley example, is it possible to simply list the % and not the total items and the %? See example attached.
Thank you!

central valley.png 68.7 KB


7. Re: Calculated %'s add up to 99%, 100% and 101%
Okechukwu Ossai May 16, 2018 11:32 AM (in response to s.sprague)1 of 1 people found this helpfulYes and No.
It's very difficult because that column is the Row Total Column. You have 2 measures on the Text marks (count and %). You can either completely exclude a measure from the Total in all columns and rows. However, there is no functionality to exclude a measure from the rows total in selective columns and rows of the view. Another option is to add percentage as an independent column but that won't work since it will alter the current structure of your table. If you want to completely remove Count from the Total, then right click on the measure, go to Total using (Automatic) and Select 'Hide'.
However, it seems you want to retain the totals in other rows and columns but just exclude it from the last column. The only workaround I can think of is to use a calculated field to hide the Count values. However, this means the Column Grand Total for Counts (15) won't display either. This may be a compromise if this is the format you want.
Create calculated field [Count of Records]
IF ATTR([Department]) = "Teacher  Special Education" THEN SUM([Number of Records])
ELSE
IF LAST() <> 0 THEN SUM([Number of Records]) END
END
This is a table calculation. Set it to compute using Table (across). Remember that this formula will work strictly with your current setup. "Teacher  Special Education" must be the last department in the table. If it changes then you'll need to update the formula.
Hope this helps. Please mark my answer as helpful or correct if it resolves your question.
Ossai