Format Number in the Table,Axis and Non Axis charts

Technical queries
#1

Hello Helical Insight,
I am using Helical Insight 4.1 GA. In my Reports we want to show the thousand separator to ‘dot’ instead of using the default ‘comma’ in a numeric column as well as ‘comma ’ should be shown as ‘dot’ for decimal. We follow a different notation as compared to US formatting. Is that possible. Please help.

So basically a number like 1,000,000.12 should appear as 1.000.000,12

Thank You,
Vema

#2

Hello Vema,
We have modified scripts to fulfill the requirement. Please download scripts.zip (133.9 KB), it contains ReadMe.txt of how to deploy and usage of the functionality.

This will work for table, pie, donut and other line charts.

Example of Axis chart :
Default tooltip value : 70,864.50
Updated axis charts tooltip gives the format : 70.864,50

image

Thank You,
Helical Insight.