TM1 Forum

We have migrated to IBM PA Local 2.0.7 from IBM Cognos Express 10.1 a fortnight ago. The data rendering/format on the TM1 web as quite ok.
Using the following format at Excel cells
_-* #,##0_-;-* #,##0_-;_-* "-"??_-;_-@_-
able to show/see "-" instead of 0 in the excel client and web client as well.

All of sudden today instead of showing "-" for 0 values, showing " -0" in TM1 web client only. Excel client show the values as anticipated.
Right from Cognos Express 10.1 these excel cells are having the format as _-* #,##0_-;-* #,##0_-;_-* "-"??_-;_-@_-

Could any one help me in resolving this.

There were changes to TM1Web formatting in this release. More than likely this is the culprit. You may have to play with your formatting on these sheets.

https://www.ibm.com/support/knowledgece ... tting.html

We have seen this as well. It's also to do with some automatic formatting.
Have a look at:
Tm1_64\webapps\tm1web\WEB-INF\configuration\features.json
to the "NewDataFormatter" property.