Page 1 of 1
Question about formatting rule calculated cells in TM1
Posted: Thu Sep 12, 2019 4:54 pm
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!
Re: Question about formatting rule calculated cells in TM1
Posted: Thu Sep 12, 2019 5:52 pm
by Wim Gielis
They should still be formatted as currency.
Did you apply formatting to elements of other dimensions in that cube ?
Re: Question about formatting rule calculated cells in TM1
Posted: Thu Sep 12, 2019 6:04 pm
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!
Re: Question about formatting rule calculated cells in TM1
Posted: Thu Sep 12, 2019 7:53 pm
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.