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.

  1. 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.
  2. 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.
  3. 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.
  4. 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%