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)