Post reply

Percentage Total

  • July 20, 2016 at 7:55 am

    #328018

    Hi,

    I have a SSRS table with a total colummn. I need to create a percentage from it but for some reason when I tried dividing both sums but it was giving me an over all percentage. Can someone please help.

    =SUM(Sum(Fields!DNA.Value, "Main_Dataset")/Sum(Fields!Total.Value, "Main_Dataset"))

    Thanks for any help.

    Paul

  • July 20, 2016 at 8:10 am

    #1891075

    can you share what is your desired output should look like?

  • July 20, 2016 at 8:11 am

    #1891077

    What is the actual value you're looking for? You haven't explained that. The formula you've provided though will provide the overall percentage, so if that's not what you're after what is your aim?

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • July 20, 2016 at 8:13 am

    #1891079

    So in the first white box underneath the red boxes should be (1323 / 8201) = 16% and the other one should be (1 / 351) = 0.28%.

    Thanks

  • July 20, 2016 at 8:24 am

    #1891083

    check the following Calculating Totals and Other Aggregates (Reporting Services)

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

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