IBM Apptio

 View Only

 Metric shorthand formatting

Jump to  Best Answer
  • CostingStandard(CT-Foundation)
Apptio Community Member's profile image
Apptio Community Member posted 04/19/21 04:12 PM
Is it possible to show metrics in shorthand format? For example: Show the cost metric as $1M instead of $1,000,000. I know it is possible with KPIs but I can't figure out how to do the same for metrics in a table.
#CostingStandard(CT-Foundation)
Guillermo Cuadrado's profile image
Guillermo Cuadrado posted 04/20/21 04:28 AM  Best Answer
I have done it in some reports by dividing by 1,000,000 and showing it with one decimal only, but you're subject to cardinality issues, @rachel yaghoubzadeh.
Sure, you could examine the number and divide by 1K / 1M or not at all, adjusting the units accordingly, but it sounds like an enormous overhead for very little gains.
Maybe someone else knows more about this.​
#CostingStandard(CT-Foundation)
Apptio Community Member's profile image
Apptio Community Member posted 04/27/21 05:00 PM
Hi Rachel,
If you add the metric to the table as a synthetic column you can specify Advanced Number Formatting to achieve the shorthand you're looking for.  Take a look at the attachment to see an example.    
=NumberFormat($_,"#.#",compact=A) 
#CostingStandard(CT-Foundation)
Attachment  View in library
Capture.PNG 153 KB

Related Content