Post reply

Decimal rounding in SSRS expression

  • November 29, 2013 at 2:59 am

    #280515

    Hi,

    I have a requirement in my SSRS report where the decimals up to 6 places has to be shown. But when the value is 0, it should be 0.00 rather than 0.000000. How can I achieve this with any expression..?

  • November 29, 2013 at 3:14 am

    #1669784

    Hi,

    How about something like the following as the format expression;

    =iif(Fields!YourField.Value=0,"N2,"N6")

  • November 29, 2013 at 3:30 am

    #1669788

    Paul is right

    if you looking for code it will look something like this

    =IIF(Fields!TotalDue.Value = 0,"0.00;(0.00)","0.000000;(0.000000)")

  • November 29, 2013 at 5:53 am

    #1669811

    Thanks for the replies....I will try this.

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

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