IBM Support

How to hide zeros in a TM1Web websheet ?

Question & Answer


In Excel there are few possibilities to show zeroes as blank in a sheet : - In the Excel Options, Advanced, option "Show a zero in cells that have zero value" - Create a Custom Style that applies white color for both font and cell background if value is zero. But none of these solutions work in TM1Web : the zeros reappear.


There is a third solution, that works in TM1Web :

- Select the desired cells or columns either in crosstab or in the TM1RPTFMTRNG range of formatting cells (the first few hidden lines at the top of the sheet)

- Right-click, select "Format Cell...", "Number" tab, and select "Custom"

- Type custom format:


In TM1Web as in Excel, all zeros will appear blank.

[{"Product":{"code":"SS9RXT","label":"Cognos TM1"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"TM1 Web","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.1.1;10.2;10.2.2","Edition":"All Editions","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
15 June 2018