Decimal Precision on a Bar chart

[Dan Brown2]

Hi,

I have a Bar chart that uses SUM aggregation of a field.  By default the Decimal Precision is to 2 decimal places

and it shows:

But when I change it to

It looks like this.

Surely the two 00 after the decimal point should not be there?

Any advice?

Many thanks,

Dan

[AnubhavRitolia]

According to ServiceNow, Decimal Precision will tell the accuracy of Decimal number. If you put it as 0, it means you don't want any Decimal values and it should append .00 only. So you need to put value between 0 to 4. 2 is default.

https://docs.servicenow.com/bundle/quebec-now-intelligence/page/use/reporting/reference/value-formatting-reports.html

Please mark this as correct answer if it resolved, or mark this helpful if this help you to reach towards solution.

[Dan Brown2]

But adding 0 still gives you 2 decimal places even if they are 00.  so it is not working correctly surely?

Thanks

[Uncle Rob]

I'm curious to see how it would work on a decimal field since those fields don't assume a format.

Currency field assumes a xxx.xx format, so in this case the precision is just rounding, not changing the way the field formats

[Maciej Kowalski]

I think you should try with more decimal places then 2 to see if it works good