Format the values on DataPoints to ###,###

[techvarun]

Hello Qlixperts

                       Happy new year to all!!!

I want to format the value on the Data points to ###,###

I want to display 65042 as 650,42..

Please advice something to acheive the result

Thanks

Varun

[#2 · Accepted solution]

Hi Varun,

you have several options, first you could use the Num() function around your expression to adjust the format to your desired output.

Num ([Expression], '###,###')

Or you can use the number tab within the chart properties.

hope that helps

Joe

[morganaaron]

In your expression, wrap it in the num() function and specify your desired output, so:

Num([Your Expression], '###,###')

[techvarun]

Thanks Aaron Morgan and JoeSimmons

     I have a container and 4 bar charts init, The above sollution is works fine for three charts and for one chart I am not able to Change the format

Any Idea to sort this out?

Appreciate your help

Thanks

Varun

[morganaaron]

What type of chart is it, and what's the expression?