Log in  ::  Register  ::  Not logged in

 Recent PostsRecent Posts Popular TopicsPopular Topics
 Home Search Members Calendar Who's On

 Group total expression Rate Topic Display Mode Topic Options
Author
 Message
 Posted Wednesday, July 30, 2014 12:43 PM
 SSC-Enthusiastic Group: General Forum Members Last Login: Tuesday, April 12, 2016 5:59 PM Points: 130, Visits: 669
 I want to add a column after Total lets say..'Progress' where Progress = sum(Actual)/sum(Budget)The only filter on Progress is to consider only those values from months where both Actual and Budget are present.So, e.g.For first row: 0/0 = 0For second row: 0/0 = 0For third row: 28334/67060(instead of 200511) = 0if there would have been an Actual value for the month of August e.g. 100, then (28334+100)/(67060+66614)For fourth row: 0/0 = 0How can I achieve this using expressions in SSRS?Thanks in advance
Post #1597911
 Posted Wednesday, July 30, 2014 5:13 PM
 SSC-Enthusiastic Group: General Forum Members Last Login: Tuesday, April 12, 2016 5:59 PM Points: 130, Visits: 669
 Any help guys..
Post #1598035
 Posted Wednesday, July 30, 2014 9:17 PM
 SSCrazy Group: General Forum Members Last Login: Yesterday @ 9:57 PM Points: 2,134, Visits: 12,265
 Help us help you. Could you post some dummy data? Just something for us to start with instead of starting from scratch?
Post #1598076
 Posted Monday, August 4, 2014 8:57 AM
 Mr or Mrs. 500 Group: General Forum Members Last Login: Friday, December 2, 2016 12:47 PM Points: 560, Visits: 1,304
 The RunningValue function might be what you need here, check out this post:http://mangalpardeshi.blogspot.com/2009/03/runningvalue-function-reporting.htmlYou'll likely need to play with the group value you're passing to the function, it talks about that in the second section.Hope that helps!Cheers,EJM
Post #1599293

 Permissions

 Copyright © 2002-2016 Redgate. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.