Page 1 of 1
Custom Number Format to Make Zeros display -?
Posted: Mon Oct 26, 2020 6:58 am
by kiss351523
What is the full custom number format for making zero values display the symbol "-" in TM1?
thks!
Re: Custom Number Format to Make Zeros display -?
Posted: Mon Oct 26, 2020 8:09 am
by 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:
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.
Re: Custom Number Format to Make Zeros display -?
Posted: Mon Oct 26, 2020 10:13 am
by lotsaram
declanr wrote: ↑Mon Oct 26, 2020 8:09 am
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.
Re: Custom Number Format to Make Zeros display -?
Posted: Thu Oct 29, 2020 1:39 pm
by semaxan
I was helped to get the following format in Architect without showing any decimals but with thousand separation using spaces.
Re: Custom Number Format to Make Zeros display -?
Posted: Thu Oct 29, 2020 1:44 pm
by 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.