Post reply

Group total expression

  • July 30, 2014 at 12:43 pm

    #293880

    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

  • July 30, 2014 at 5:13 pm

    #1733870

    Any help guys..

  • July 30, 2014 at 9:17 pm

    #1733906

    Help us help you. Could you post some dummy data? Just something for us to start with instead of starting from scratch?

  • August 4, 2014 at 8:57 am

    #1734873

    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

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply