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: Today @ 11:40 AM
Points: 114, Visits: 526


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: Today @ 11:40 AM
Points: 114, Visits: 526
Any help guys..
Post #1598035
Posted Wednesday, July 30, 2014 9:17 PM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Today @ 9:47 AM
Points: 774, Visits: 4,982
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
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 10:32 AM
Points: 295, Visits: 826
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