Decimal Value Display Issue in PA Line Chart – Hours Show as 3108 Instead of 3.108
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-30-2025 10:49 AM
I'm facing a display issue in Performance Analytics (PA) with a Formula Indicator used in a line chart visualization.
Here’s the scenario:
The original result is 3.108 hours, but it's displaying as 3108
To correct this, I converted it to days by dividing by 24, resulting in 0.1294
However, PA now displays this as 129 instead of 0.1294
So it looks like the value is being automatically scaled or misinterpreted as a percentage — even though:
There’s no “Show as Percentage” option in the widget
I’ve set Precision to 3
Unit is set to "days"
Is there a configuration I’m missing in the Formula Indicator or widget?
Is this expected behavior in PA line charts for small decimal values?
Is dividing by 100 a recommended workaround — or is there a better way to show actual decimal values (like 0.1294) correctly?
- Labels:
-
Performance Analytics
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-01-2025 02:52 AM
Maybe I am missing something, but it could a different way in writing decimals in different countries, which could also be your issue. After reading your question multiple times, I think you aren't talking about 3000 + hours, but 3+ hours, right?
Check the localization on your instance, because I think the issue is in there, where the decimal '.' isn't seen as decimal and it's expecting a comma.
It really depends on the settings to resolve this. A quick fix for now could be to update the formula to divide the original result by 1000.
Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark