SSRS - Sum of calculated percentage

0
votes

I have a summary tablix that contains 2 columns 1) Count 2) Percent. The Percent value is calculated based on the count divided by total count. For example, to get 35.8% it is 1,011 divided by total count of 2,824. I'm trying to SUM up the total Percentage column to show a 100% total, but since it is an expression I'm not sure how to sum up the Percentage column.

I tried adding a total below and using expression =ReportItems!SubCallCount.Value / ReportItems!TotalCallCount.Value, and I'm not getting the 100% total.

enter image description here

1
reporting-servicesssrs-2008ssrs-2008-r2
Are you trying to sum the rounded down versions of the numbers? if not then why sum at all? You know the result will be 100% so you could just set the cell to be 1 – Alan Schofield

1 Answers

0
votes

Better you use expression as =ReportItems!SubCallCount.Value /ReportItems!SubCallCount.Value