I'm attempting to use the formatstring property in my cube measures to format values similar to the 'currency' format but without the '$'.
I tried using #,##.## but in the cells without values, I always see the '.'
How can I format these values to show nothing in the null cells and no '.' where there is nothing after the decimal point?
To be more specific:
Currently in cells with null values I am seeing "." In cells where there is nothing after the decimal I am seeing a value such as: "1234." In cells where there is something after the decimal I am seeing "1234.56"
What I would like to see is " ", "1234", and "1234.56" respectively. Is this possible using the formatstring property?
You can probably fix the issue of the "." in null cells by using the 4 part format string to specify a different format mask for null values.
<positive> ; <negative> ; <zero> ; <null>
I don't know if there is anything that you can do about the trailing zero, Excel does the same thing if you specify the same format mask. http://geekswithblogs.net/darrengosbell - please mark correct answers