Remove rounding or show 2 decimals

[chris_alanis]

Hi All,

One issue in the way PA shows is that it rounds the numbers, eg- we have 1.61M XYZ in 2023 and it shows as 2M. This is a challenge and would be great if we can remove rounding or show 2 decimals. 

The ideal option will be to have 2 decimals in the scorecard view.

I tried by removing the kMGTPE default value from the scores_format (Number format) field in the pa_indicators (Indicator) table and didn't work.

Thanks in advance,

Cristobal

[AndersBGS · Accepted solution]

Hi @chris_alanis ,

According to investigation, I don't think that this is possible to adjust for performance analytics. You can see this document for reference: https://docs.servicenow.com/bundle/washingtondc-now-intelligence/page/use/performance-analytics/conc... or the KB article: https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0717732

When we instead look at normal reports, you have the value formatting to select/deselect the abbreviation.

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

best regards

Anders

[chris_alanis]

Thanks for your help on this @AndersBGS 

[chris_alanis]

The request changed; they now want to see the whole number.

The Widget Type is Breakdown and Visualization Scorecard.

I've been playing around with no luck so far.

[Tricia Cornish]

@chris_alanis  - I realize this is a bit of an old post, but thought you might find the following helpful. 
To address this issue: "One issue in the way PA shows is that it rounds the numbers, eg- we have 1.61M XYZ in 2023 and it shows as 2M", this is due to your precision field in your indicator. Depending on whether it is an automated indicator or a formula indicator, you'll want to make sure your precision field is populated. If it's a formula calculation comprised of automated indicators, test to see if the automated indicators precision affects your calculation. the formula result will display based on the formula precision.  
For your larger question about rounding in PA, I tried a few scenarios - perhaps 1 will work for you. 
Here is my example -the name of my indicator is "Manual Indicator: 4 digits, 2 dec, precision is 2) so I know I entered values in the scoresheet with decimals. 

The scores for this indicator are as follows:

In the legacy performance analytics, there will always be rounding.
These are the indicators I created (manual for data, formula for display)

Your indicator precision is not necessarily your display precision. As @AndersBGS suggested, you might want to set decimals.  As an example, for the last score, I entered 456.777, but the manual indicator and all the formulas with a precision = 2 display 456.78. The formula indicator that displays precision = 3, displays the value I entered. 
The display value for line 2, the manual indicator has not changed, but the formula precision is set to 0, rounds up to 457. 

There are indicator methods that might be helpful. This is formula config displayed in line 4 in my group above. 

You can find more about indicator methods here: https://docs.servicenow.com/bundle/xanadu-now-intelligence/page/use/performance-analytics/task/get-i...

There is a way to use javascripts in formula indicators to round and/or set toFixed or toString. Can be done, not documented, that formula window can accomodate javascript. 

This might be the motivating requirement to move to Platform Analytics (you can migrate your dashboards) 
In this example, you can see that in my visualizations, I can now determine if there is formatting applied, additional rounding scenario,  and if you enable the abbreviation (kMGTP)