HELP: How to add Total to a row in a calculated column of a Matrix
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 I do? What should I do?
November 25th, 2010 11:44am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics