Percentage Calculation In SSRS

Question

when i am calculating like given below in SSRS 2008

=SUM(IIF(Fields!REMARKS.Value = "GOOD",1,0))/((SUM(IIF(Fields!REMARKS.Value = "GOOD",1,0))+ SUM(IIF(Fields!REMARKS.Value = "BAD",1,0))))*100

getting result like 34.9632565235


but i am trying to get result like 34.97%

Please share your expertise.

Thanks

Answer 1

Try:

=FORMAT(
SUM(IIF(Fields!REMARKS.Value = "GOOD",1,0))/
((SUM(IIF(Fields!REMARKS.Value = "GOOD",1,0)) +
SUM(IIF(Fields!REMARKS.Value = "BAD",1,0)))),"P2")

Or you can use a custom string format:

=FORMAT(
    SUM(IIF(Fields!REMARKS.Value = "GOOD",1,0)) /
    ((SUM(IIF(Fields!REMARKS.Value = "GOOD",1,0)) +
    SUM(IIF(Fields!REMARKS.Value = "BAD",1,0)))*100)
,"0.00") & "%"

Let me know if this helps.