Apologies if this is already common knowledge.
I discovered today that the Excel technique of including "_)" in the postive area of a custom number format, in order to align positive values with negative numbers enclosed in brackets (or 'parentheses'), also works in TM1. I cannot see from the documentation how it is so, but the following gave me the desired result, and would surely bring joy to the hearts of accountants everywhere. They do have them (hearts).
BTW it includes dashes instead of zeros.
#,##0_);(#,##0);'-';' '
Regards, Ian
Excel aligned negative number formatting
-
- Community Contributor
- Posts: 109
- Joined: Thu Feb 26, 2009 8:44 am
- OLAP Product: TM1
- Version: 9 + 10 + Plan An
- Excel Version: All
- Location: Isle of Wight, UK
Excel aligned negative number formatting
"the earth is but one country, and mankind its citizens" - Baha'u'llah
-
- Community Contributor
- Posts: 109
- Joined: Thu Feb 26, 2009 8:44 am
- OLAP Product: TM1
- Version: 9 + 10 + Plan An
- Excel Version: All
- Location: Isle of Wight, UK
Re: Excel aligned negative number formatting
....and to make it even better,
#,##0_);(#,##0);-_);
which lines up the dashes too.
#,##0_);(#,##0);-_);
which lines up the dashes too.
"the earth is but one country, and mankind its citizens" - Baha'u'llah