Calculation formats
When a calculation is added to a view, TM1 formatting is applied to the calculation.
The formatting that is applied to a calculation is determined in the following order of priority.
- The format of the selected members in the calculation. If the calculation uses a range selection, then the format is limited to the start and end member of the range.
- The format of the overview context members, going from right to left.Note: In versions earlier than 2.0.48, the format of the overview context members is determined by going from left to right.
- The format of members on the bench, going from bottom to top.Note: In versions earlier than 2.0.48, the format of members on the bench is determined by going from top to bottom.
- If no format is found for a member, then a default format of
#,##0.00;(#,##0.00)
is applied. For example, the value 256694.89 is formatted as 256,694.89.
Exceptions
Rank calculations always use the format #,##0
.
Percentage calculations always use the format ##0.00%;-##0.00%