Format_string in icCube does not format null values
I was trying to display values ββthat are 0 using format_string.
I currently have the following:
WITH
MEMBER [test] AS null, FORMAT_STRING = '0.#;Neg (0.#);0.00;0.00'
SELECT
[test] ON COLUMNS
FROM [Sales]
The fourth value (; 0.00) should format zeros to zeros. I read this here: https://msdn.microsoft.com/en-us/library/ms146084.aspx
It is currently showing nothing. It should show 0.00.
You can try it here: http://www.iccube.com/run-mdx
+3
source to share
1 answer
This is a bug ( ic3pub_159) and will be fixed in the next version. You can use the coalesceEmpty MDX function as a workaround .
CoalesceEmpty( [MyValue] , 0.0 )
+4
source to share