SSRS expression to format two decimal places does not show zeros

Question

I am using the following expression to format my value to show only two decimal points  Which Works fine if the value is not 0  However when the value is 0 it does not show 0   eg   Expression used   Format Fields CUL1 Value             If CUL1 Value is 2 5670909 the value shown in the report 2 56  this is brilliant   If CUL1 Value is 0 006709  no value is shown  I would like it to show 0 00  If CUL1 Value is 0 no value is shown   I would like to show 0   Thanks

User · Answer

You need to make sure that the first numeral to the right of the decimal point is always displayed. In custom format strings, # means display the number if it exists, and 0 means always display something, with 0 as the placeholder.

So in your case you will need something like:

=Format(Fields!CUL1.Value, "#,##0.##")

This saying: display 2 DP if they exist, for the non-zero part always display the lowest part, and use , as the grouping separator.

This is how it looks on your data (I've added a large value as well for reference):

enter image description here

If you're not interested in separating thousands, millions, etc, just use #0.## as Paul-Jan suggested.

The standard docs for Custom Numeric Format Strings are your best reference here.

User · Answer

If you want it as a string use    Format Fields CUL1 Value   F2    As a number use    FormatNumber Fields CUL1 Value  2   This will ensure it exports out to excel correctly as a number

User · Answer

Please try the following code snippet    IIF Round Avg Fields Vision Score Value     Avg Fields Vision Score Value    Format Avg Fields Vision Score Value     FORMAT Avg Fields Vision Score Value              hope it will help  Thank-you

User · Answer

If you want to always display some value after decimal for example  12 00  or  12 23  Then use just like below   it worked for me  FormatNumber  145 231000  2  Which will display 145 23  FormatNumber  145  2  Which will display 145 00

User · Answer

Actually  I needed the following   get rid of the decimals without rounding so  12 23  needs to show as  12   In SSRS  do not format the number as a percent  Leave the formatting as default  no formatting applied  then in the expression do the following   Fix Fields PctAmt Value 100    Multiply the number by 100 then apply the FIX function in SSRS which returns only the integer portion of a number

User · Answer

Format Fields CUL1 Value   0 00   would work better since  abe suggests they want to show 0 00   and if the value was 0    0     would show  0

[service] SSRS expression to format two decimal places does not show zeros

Examples related to service

Examples related to reporting-services

Examples related to reporting