none
Percentage Calculation using SSRS 2008 R2

    Question

  • Hi,

    I have a dataset which includes 2 fields CaseRef, Concluded (Yes/No). I am displaying this in detail in a table. I would like to display the percentage and the formula will be, 

    TotalCount of Concluded where it is Yes / Total CaseRef * 100. How would I do this in reporting services?

    Regards,

    MH


    MH

    Wednesday, November 20, 2013 4:10 PM

Answers

  • Hi,

    Add a calculated field in dataset based on Yes , let it give Value 1 and 0 for No.

    Add Group in table and then apply formula in group row

    =Sum(newfield)/count(newfield)*100

    This should resolve

    Cheers,

    Sushil

    sushil@grokinnovations.co.uk

    www.grokinnovations.co.uk


    Sushil Saini Grok Innovations Uk Ltd www.grokinnovations.co.uk

    • Marked as answer by MustafaH Wednesday, November 20, 2013 4:41 PM
    Wednesday, November 20, 2013 4:22 PM