UNDEFVALs in PAX vs Websheets
Posted: Wed Sep 02, 2020 7:04 am
Hi All,
Do anyone of you tested publishing pax(pafe) view using undefvals as a websheet (Quick Reports) to tm1web?
I have view like this in excel and I would lkie to get the same way of 0 vs null values display in tm1websheet:
Using undefvals and element formatting like this:
After publishing it to tm1web i get the view like this:
As You can see, users cannot see clearly which cells contain 0 and which have null values. In tm1web cubeviews it is okay, but users wanted to work in dynamic tables and excel-like charts so thats why it must be done with websheets. I was trying different browsers and language settings but it always looks the same....
I have tested different reports and it looks like this only appears in quick reports which i was using, so i will try to recreate my websheets using e.g. custom reports, but still this situation is a little bit weird for me.
Do you have any ideas or suggestions where to search for an answer to that?
Do anyone of you tested publishing pax(pafe) view using undefvals as a websheet (Quick Reports) to tm1web?
I have view like this in excel and I would lkie to get the same way of 0 vs null values display in tm1websheet:
Using undefvals and element formatting like this:
After publishing it to tm1web i get the view like this:
As You can see, users cannot see clearly which cells contain 0 and which have null values. In tm1web cubeviews it is okay, but users wanted to work in dynamic tables and excel-like charts so thats why it must be done with websheets. I was trying different browsers and language settings but it always looks the same....
I have tested different reports and it looks like this only appears in quick reports which i was using, so i will try to recreate my websheets using e.g. custom reports, but still this situation is a little bit weird for me.
Do you have any ideas or suggestions where to search for an answer to that?