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".
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
Super User
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".
I ended up doing this. Unfortunately, it makes conditional formatting a little trickier but this is the best solution.