Dimension Formatting

[KarenBC]

Hi all,

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?

Thanks

[vikasmahajan]

Hi,

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