TM1 Forum

Hi there, does anyone know how to make a zero value blank in PA. The methods in TM1 have caused an issue with PAW (returns an error for zero) and PAX (returns #Value from any excel calcs referencing the blank). Obviously still works in architect when developing.

My fix is forcing a zero, which I can live with, But just checking I am not missing another option. This one works but does not display as blank: I have tried # and "", and _) for the zero values, but 0 is the one that works (probably because out of all those options it is the only one which is an actual number)

BTW - I found leaving the zero area of format blank worked for PAX but not PAW (get error on zero cells)

Leaving blank for zero SHOULD work and if it doesn't it's a bug.
E.g. 0;-0;
That's the universally standard and accepted method to specify blank for zero or null.

thanks lotsaram

Probably a bug but IBM support were not that interested, maybe it will be fixed, but it is an issue at the moment.

Cheers

I raised this with IBM. They mentioned that the number formatting must be on "0.00" for this to work. They mentioned it would be fixed in future releases.

I found this on 10.2.2 FP3.

HTH