Is it possible to remove the decimal places from a KPI. If so, how? For example (with made up numbers), I don't want to see $50.33M. I just want $50M

Thanks,

Devon

Hi @Devon Bilsing,

If you select the KPI in the report within TBM Studio, and you select the KPI option in the ribbon, there is a button there labeled "Shorthand." You can specify the Notation Type and have that KPI specifically rounded to the thousands, millions, billions, or trillions. 

The option labeled All Notations will automatically select the best rounding, but will default to two decimal places in the example that you mentioned above. 

One thing to keep in mind is that if you're modifying the KPIs in this way on an Out of the Box report, you'll need to re-apply these settings after an upgrade as this would be seen as a customization of the report. However, if it is a custom report that you've built, then you won't have to worry about re-applying these settings post-upgrade.

Hope this helps!

Hi @Katie Mansfield, I have the Notation Type set to millions however I still have decimals. I am experiencing no difference between All Notations and Millions. 

Hi @Devon Bilsing,

Thank you for the additional information. Is this a standard Apptio report, or a custom report that you've built (or are you seeing this universally, across all reports even if you select the Millions option for Notation type on each KPI widget)?

And are you seeing it on both the main/primary number as well as the smaller font/secondary number?

The last clarification question that I have for now, to allow me to find the right resources: is this a custom or previously modified Metric, or is this a standard and unmodified Metric KPI?

@Katie Mansfield We are seeing this across reports, the majority of which are custom. Yes, both the primary and secondary. And both types of metrics. 

@Devon Bilsing, which product are you working on in TBM Studio? I'm trying to replicate it on my side and want to be sure that I'm following the behavior as closely as I can. I'm also reaching out to the team at-large to see if someone has run into this before.
There have been a few ideas on potential changes to the configuration of the metrics by setting the format to avoid using decimal places. I'm looking for a change that won't require modifying the metrics, in the interest of ease.

Hi @Devon Bilsing,

Here are some settings that may help you to set the behavior of the numbers (within the Properties of the Metric itself). You might want to try both of these, or trying one at a time to see if it's affecting your KPI the way you're hoping that it will. It might be Chart format, because it's in the reports, but that may just affect how it's displayed when it's specifically within a Chart and not a KPI widget.

@Katie Mansfield, I work with @Devon Bilsing in the same company. I saw your response and tried what you suggested. You are correct -- by putting this formula (=Currency($_,"###,###") in the Table Format section only will do the trick. 

Hi @Devon Bilsing, I can't speak to R12... but as these are mostly custom reports, you may consider using a custom HTML component, rather than a KPI.  Within the HTML, you can then leverage the Currency or NumberFormat functions, to limit the decimal places.  

Below is an example of something we previously built:

Hope that helps.  Good luck!