I have a requirement to add a large number of numerical dimensions to a chart, and i want to display them with thousand seps (','). If i add them as a measure, i get the number formatting option, for a dimension we dont get that. In order to display the numbers correctly (as 1,000 rather than 1000), I know i can change the value to num(field,'#,#0') in the front end, but then i get ugly values if an end user selects that field for any filtering. Unfortunately I have too many numeric fields to set them to num(field,'#,#0') as part of the script.
Is there a way to set any sort of environmental setting to make sure any number dimensions are displayed in a particular format?
Here in environment settings in script you can fix your number format which will apply to all documents. SET MoneyFormat='₹ #,##0.00;-₹ #,##0.00';
hope this help
Vikas
Hope this resolve your issue. If the issue is solved please mark the answer with Accept as Solution & like it. If you want to go quickly, go alone. If you want to go far, go together.
