Monday, March 12, 2012

How do I format zeros (0) to display as dashes (-)?

I am using the current formula and it works. #,###,;(#,###,) How do change
this formula to display the zeros as dashes?
Thanks in AdvanceUse the below expression
=Iif(Fields!Measures_TxnCount.Value=0,'-',
Fields!Measures_TxnCount.Value)
I hope this should solve u r problem
OriginalStealth wrote:
> I am using the current formula and it works. #,###,;(#,###,) How do
change
> this formula to display the zeros as dashes?
>
> Thanks in Advance

No comments:

Post a Comment