Custom Number Format to Make Zeros display -?

[kiss351523]

What is the full custom number format for making zero values display the symbol "-" in TM1?

thks!

[declanr]

The number formats apply a similar logic to excel number formatting where it is split into 3 sections:
1/ Positive Numbers
2/ Negative Numbers
3/ Zeroes

Apply number formats to a dimension element ends up with slightly different connotation in Architect vs Workspace but the part you care about si the same:

Code: Select all

#,##0;(#,##0);-

In that example it uses a comma for thousand separator, encloses negatives in brackets and does not show decimals. The bit you care about is after the last semi-colon ( ; ) and it is just a hyphen/dash in order to show a dash.

[lotsaram]

In that example it uses a comma for thousand separator, encloses negatives in brackets and does not show decimals.

Strictly speaking it doesn't enforce using comma as the thousand separator. Whatever the local regional settings are on the user's desktop for thousand separator will be substituted.

[semaxan]

I was helped to get the following format in Architect without showing any decimals but with thousand separation using spaces.

[semaxan]

Actually, instead of using a short hyphen - I preferred the longer en-dash (ALT+0150). You could also use the even longer em-dash ALT+0151. But the middle one is the one I use.