Hey guys, I guess the title wasnt the best representation of my problem, so basically what I need is to add a total of a row so I can count how many developments were closed under a certain SLA. So I created a matrix like the one below, let's say that the SLA for Bugs is 30 hours and for UserStories is 55 hours. What I need to work is the column "Leadtime On Track" to identify and quantify the volume of bugs and UserStories within these SLA, ok? So the matrix was built with the following structure: - group by EntityType (bug ou userstory), - group by EntityID (101010,101011,101012....n), - Qty: [Count(EntityID)] - Avg LeadTime: round(Avg(Fields!CycleTime.Value),2) - LeadTime: =round(sum(Fields!CycleTime.Value), 2) To identify the ones under the SLA I used the following formula, which worked: =iif(((Fields!EntityType.Value.Equals("Bug")) andalso (sum(Fields!CycleTime.Value))<=30) or ((Fields!EntityType.Value.Equals("UserStory")) and (sum(Fields!CycleTime.Value))<=55), 1, 0) however it only works on the dimension "EntityID", because where I tried to have the overall, dimension EntityType, by attempting to count or sum the flag "1", it returns me 0 or the Qty value repectively. I dont know whatelse to do. DEMAND QTY AVG LEADTIME LEADTIME LEADTIME ON TRACK Bug 7 2.87 188.46 ?--> 3 <--? 101010 1 1.44 24.12 1 101011 1 2.67 44.99 0 101012 2 2.49 31.23 0 101018 1 3.89 27.46 1 101019 1 1.32 38.37 0 101020 1 5.45 22.29 1 UserStory 10 16.63 253.12 ?--> 3 <--? 101013 2 10.44 64.12 0 101014 2 20.67 54.99 1 101015 4 12.01 41.28 1 101016 1 23.01 37.63 1 101017 1 17.01 55.10 0 Total 17 9.13 441,58 ?--> 6 <--? What should a do?

Hi, Do you mean you have tried to calculate the sum of the LeadtimeOnTrack by using the expression like =Sum(iif((Fields!EntityType.Value.Equals("Bug") AndAlso Sum(Fields!CycleTime.Value) <= 3) Or (Fields!EntityType.Value.Equals("UserStory") And Sum(Fields!CycleTime.Value) <= 5), 1, 0)) If this expression returns incorrect number but not an error message, the version of your Reporting Services might be 2008R2 due to nested aggregate function can only be used in this version. If not, please point out. In Reporting Servecis 2008R2, we need to modify the expression with the scope specified to the aggregate function, please refer to the expression below =Sum(iif((Fields!EntityType.Value.Equals("Bug") AndAlso Sum(Fields!CycleTime.Value,"EntityID") <= 3) Or (Fields!EntityType.Value.Equals("UserStory") And Sum(Fields!CycleTime.Value,"EntityID") <= 5), 1, 0),"EntityType") The arguments "EntityID" and "EntityType" indicate the group name in the Tablix, please change them to the corresponding names in your report. Thanks, Tony ChainPlease remember to mark the replies as answers if they help and unmark them if they provide no help