Question about formatting rule calculated cells in TM1

Post Reply
lynnsong986
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

Post by lynnsong986 »

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!
Wim Gielis
MVP
Posts: 3105
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

Post by Wim Gielis »

They should still be formatted as currency.
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
lynnsong986
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

Post by lynnsong986 »

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!
lotsaram
MVP
Posts: 3651
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

Post by lotsaram »

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.
Post Reply