Post reply

Need a total of calculated values in a column

  • June 7, 2017 at 12:11 pm

    #343102

    Hi Everyone,
         I am having an issue with a report, so I hope you all can help me....

    I have a table in a SSRS report that shows a Order description, how many were ordered and total price.  The total price is a calculated field derived from the number ordered multiplied by a set price which is set in an expression.

    Now, is there any way I can do a running value or sum of the calculated field and get a grand total?

    Thanks!

  • June 7, 2017 at 1:47 pm

    #1945892

    If you added the calculated field to your dataset, then you can use it just like a normal field (as it if were in the original dataset). If not, I don't think so.

  • June 8, 2017 at 7:12 am

    #1945984

    Use
    =RunningValue(Fields!calculatedfield,Sum,Nothing)

    Far away is close at hand in the images of elsewhere.
    Anon.

  • June 8, 2017 at 7:18 am

    #1945985

    Thanks guys!  I actually added the calculated field in my SQL query.  mad it a lot easier to do it that way.

    Thanks again!

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

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