Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Group total expression Expand / Collapse
Author
Message
Posted Wednesday, July 30, 2014 12:43 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, October 29, 2014 3:19 PM
Points: 115, Visits: 546


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 = 0
For second row: 0/0 = 0
For third row: 28334/67060(instead of 200511) = 0
if 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 = 0

How can I achieve this using expressions in SSRS?
Thanks in advance
Post #1597911
Posted Wednesday, July 30, 2014 5:13 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, October 29, 2014 3:19 PM
Points: 115, Visits: 546
Any help guys..
Post #1598035
Posted Wednesday, July 30, 2014 9:17 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 5:12 PM
Points: 928, Visits: 5,902
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
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 8:43 AM
Points: 365, Visits: 903
The RunningValue function might be what you need here, check out this post:

http://mangalpardeshi.blogspot.com/2009/03/runningvalue-function-reporting.html

You'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
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse