BKW
Ten Centuries
Points: 1350
More actions
February 27, 2009 at 10:11 am
#197562
How do I show blanks if the $ value is zero in my table. I know for numbers I can format with #,# but if I use this on money it drops the decimals.
Changinagain
March 1, 2009 at 11:37 am
#951611
Kept experimenting and got this to work:
=IIF(Fields!ColumnName.value=0,"",Fields!ColumnName.value)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply