question

1370 1 avatar image
1370 1 asked

ssrs expression

Created a pie chart and under the data value->Point labels->DataLabel:- I wrote an expression for currency => (="$" & Fields!Money.Value). However, it is showing four digit value after the '.' like ($5.0000). How can I get rid of the last 2 digit of 00. Please let me know if you have any idea. Thanks!

ssrs
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Kev Riley avatar image
Kev Riley answered

You need to set the format of the value to 'N2' - meaning numeric with 2 decimal places

2 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Fatherjack avatar image Fatherjack ♦♦ commented ·
or maybe just use the C2 value meaning currency ?!?!
1 Like 1 ·
Kev Riley avatar image Kev Riley ♦♦ commented ·
you see this is what I mean about learning something new everyday - I never knew about the 'C2' format - in fact it probably took me a couple of months of using SSRS to even work out what format the format codes took!
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.