Post reply

SSRS-Show value in field with Percent Symbol

  • July 4, 2014 at 3:41 am

    #293057

    Hello,

    I have a value in database which is already a percentage value with 7 decimal places (eg: 8.0000000) and need to display this value in the report additionally with % sign and with only 2 decimal places

    When I tried to concatenate the value with % in field expression, it is automatically multiplying the value by 100 when the value is already a percentage.

    How do I prevent SSRS from multiplying the value by 100?

    Is there a format code which I can use to append % sign and limit to 2 decimal places?

    =(Fields!Q1.value) & "%"

    Thanks

  • July 4, 2014 at 3:49 am

    #1727041

    I would just format the number and then append the % to it.

    Formatting Numbers [SSRS][/url]

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • July 4, 2014 at 4:06 am

    #1727048

    Thanks for the response.

    But the moment I append the %, it adds bunch of zeors after the decimal.

    Can you show me an eg of how exactly to do it?

    Thanks!

  • July 4, 2014 at 4:52 am

    #1727063

    An example:

    =FormatNumber(89.12346,2,True,False,False) & "%"

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • July 7, 2014 at 7:09 am

    #1727339

    Try either of these in Format for the cell

    ##0.00%

    or

    P2 (this will format with a space before the % sign)

    Hope this helps

    Andy

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

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