Forum Discussion
Calculation items and display units
Anonymous,
I would disable the display units and put the logic in the calculation item. For example, if you want to display an amount in thousands, in the calculation item do the following:
1. Divide the result by 1,000.
2. Use the format string expression "#,##0K".
Super UserAnonymous,
Have you tried setting the Format String Expression for each calculation item? This is done in Tabular Editor.
I have tried using the Format String Expression in the calculation items, but I haven't found a way to supersede the display units from the matrix.
My format string expressions are pretty simple currently. For the variance items, I am only using the following:
"+0.0%;-0.0%"- DataInsights
Anonymous,
I would disable the display units and put the logic in the calculation item. For example, if you want to display an amount in thousands, in the calculation item do the following:
1. Divide the result by 1,000.
2. Use the format string expression "#,##0K".