Percent difference in a subgroup

# Percent difference in a subgroup

• Monday, December 10, 2012 11:58 PM

Hi, yes i am back again, percentages on groups and subgroups

In my previous post i was able to deliver a total percentage (script after image), this is great, now i am struggling with this as a subtotal in each CurrentPriority,and then i need to give a break down of percentage for each category, i may have my table structure wrong.

So i have a total in the Patient Count Over Boundry, i want in the % Over Boundry by group of the Total WaitList Count..

Example: Cardiology 2-Semi Urgent = Total 7 and TotalWaitListCount= 56

Calculate 7/56*100

`=Sum(Count(IIF(Fields!OverBound_Flag.Value="Yes",0,Nothing)))/(Sum(Count(Fields!WaitingListId.value)))`

David

### All Replies

• Tuesday, December 11, 2012 4:02 AM

The following has fixed part of the challange

Show a percent diff for each Clinic Name

this is the script i have used in the % Over Boundry Column on (Current Priority Total Row)

`=FormatPercent(Sum(Count(IIF(Fields!OverBound_Flag.Value="Yes",0,Nothing)))/Count(Fields!WaitingListId.Value,"Tablix1"))`

Here is the output

David

• Marked As Answer by Tuesday, December 11, 2012 4:39 AM
•
• Tuesday, December 11, 2012 4:39 AM

Ok, I have it all done know...

What i did was added a Group Column (Below on (Current Priority) Group on(Clinic Name)

Expression remains the same:

`=FormatPercent(Sum(Count(IIF(Fields!OverBound_Flag.Value="Yes",0,Nothing)))/Count(Fields!WaitingListId.Value,"Tablix1"))`

My new output is:

David