Can not get "Ending 0" to display on an BI publiser report when displaying a 3-digit number or less
I have a report requirement to display values in my report as follows 1,100.6 to 1,100.60. and 100.6 to 100.60 and 10.6 to 10.60. I used the format mask #,##0.00. The format mask works on anything over a 3-digit value 100.60, but any value that is a 3-digit value or less the format mask doesn't work 100.6.
0