CODEWITHSUNDEEP
reporting-servicesnumber-formatting
Unitts
Unitts

Reputation: 11

SSRS conditional number formats

I have a report that shows an opening balance. If the balance is zero then I want to the number format #,0.00 to display as 0.00. However, if there is a credit then I want the number format #,0.00 C to display as, for example 123.45 c I'm thinking it's some kind of Switch expression but for the life of me can't get it working. Thanks in advance.

Upvotes: 1

Views: 342

Answers (1)

niktrs
niktrs

Reputation: 10056

Set the format property to the expression below

="#,0.00;#,0.00c;0.00"

Upvotes: 1

Related Questions