Laura2112
asked on
Suppressing zeros in and SSRS report
I thought that this would work, and it does, but not for all values in the column. Most.
My value is 1019. 88. Returns the space instead. Very peculiar. Any suggestions on another way to suppress 0 in the report?
=iif(Fields!WC_Price.Value = 0,"",FormatCurrency(SUM(Fi elds!WC_Pr ice.Value) ,0))
My value is 1019. 88. Returns the space instead. Very peculiar. Any suggestions on another way to suppress 0 in the report?
=iif(Fields!WC_Price.Value
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for your contribution!
ASKER