Question about formatting rule calculated cells in TM1
-
- Posts: 83
- Joined: Wed Feb 28, 2018 2:20 pm
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2016
Question about formatting rule calculated cells in TM1
Hello, I have a measure dimension named "RevenueMeas" where all elements need to be in currency format. I set the format up using "Edit Elements Attributes" as currency. However these cells are rule driven and somehow the cube view doesn't show the numbers in currency format. How can I fix this? thanks!
-
- MVP
- Posts: 3113
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.0.9.18
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: Question about formatting rule calculated cells in TM1
They should still be formatted as currency.
Did you apply formatting to elements of other dimensions in that cube ?
Did you apply formatting to elements of other dimensions in that cube ?
Best regards,
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
-
- Posts: 83
- Joined: Wed Feb 28, 2018 2:20 pm
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2016
Re: Question about formatting rule calculated cells in TM1
Thanks yes I have too many dimensions in that cube and applied formatting all over the place. I just did a clean up and it is good now, thanks again for your fast reply Wim!
-
- MVP
- Posts: 3652
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: Question about formatting rule calculated cells in TM1
The documentation explains it.
To ensure that TM1 applies the format for the cube measures, position the dimension containing the measures as the bottommost column dimension.
- TM1 first checks the elements in the column dimension for display formats. If dimensions are stacked, TM1 checks from the bottom upward.
- If no format is found, TM1 checks the elements in the row dimension for display formats. If dimensions are stacked, TM1 checks from right to left.
- If no format is found, TM1 checks the title elements for display formats. The elements are inspected from right to left.
- If no format is found, TM1 applies the format for the current view.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.