locked
Display percentage RRS feed

  • Question

  • I want to display following format in ssrs 2016. I need to display the percentage symbol for first value in tablix data.

     


    ID NAME Percentage
    1 A 60.0%
    2 B 55.8
    3 C 78.2
    4 D 87.6
    Sunday, October 1, 2017 2:22 AM

All replies

  • Hi KIRAN KUAMR,

    I want to know, Is the first value 0.6 or 60? If it is 0.6 you could set placeholder properties like below

    =iif (Fields!id.Value=1,"0.00%","0.00")

    Then you will result below

    If the percentage is 60, you could try to change expression and choose placeholder to set text to left like below

    =iif (Fields!id.Value=1,Fields!percentage.Value &"%",Fields!percentage.Value)

    Then you will get result below

    If you have any question, please feel free to ask.
    Best regards,
    Zoe Zhi

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Monday, October 2, 2017 9:47 AM