Decimal

[manoranjan_d]

in my expression i m using sum(sales) now  i want to display the number as  2,000.12.

i want figures to 1000 seperators and only extend to 2 decimal

currently in the dash board its shows 2000.1235563

how to do this,

i want to show the number values with coma operator higher number also.

[prma7799]

Num(sum(sales) ,'#.##')

[prma7799]

or in chart level

[manoranjan_d]

this will show figures to 1000 seperators with comma?

[Miguel_Angel_Baeyens]

Or rather, in the chart properties > Number > click on the expression and then "Fixed to" and specify 2 decimals.

If you want all your data like that, you might want to do it in the loading script using a Round() function

[manoranjan_d]

thanks

[prma7799]

Hi Manoranjan,

If you get your answer please mark this thread helpful or right answer.

Thanks.