Custom Number Formatting in charts

[neerajthakur]

Custom Formatting is ##,##,##,##,##,##0 when used for any measures in charts it is showing as 1+e....... in the axis rather than the number.

[vikasmahajan]

Hi,

While creating measures have you keep auto option ?

[neerajthakur]

No Auto Formatting is used.

[deepanshuSh]

You can just reduce the ##,##,##,##,##,##0 to ##,##0 it would give out the correct result. Whats happening is that the e = 100000, resulting in 1+e depiction. 

[neerajthakur]

Need to use Indian Number System and not International one

[marcus_sommer]

It should work with something like:

num(10000000000, '##,##,##,##,###','.', ',')

If your numbers are bigger as the number of #respectively 0 within the format-code it showed the output as 1e... Important by num() is further that the decimal- and thousand-parameters are also set.

- Marcus

[neerajthakur]

Nope, it's not working issue is same

[marcus_sommer]

For me it worked fine in QlikView and therefore I would expect the same in Sense. To check it create a new dummy-app with inline dummy-data with around two dozens of different length numbers and put them with such format-pattern within the properties and/or per num() into a table-chart and a different bar/line-chart. How does it look like then?

- Marcus