short number format

[#1]

I had chart city, sales.

in sales column values are,

100000,

2340000,

2345600

how to show these values in million in chart  like

1M,

2.34M,

2.3456m,

[maternmi]

Hi,

=sales/1000000 & 'M'

Hope it works

[#3]

Hi,

you have the option to override the number format within the chart properties (see attached), this can be done for each expression. The other option you have is to use Num() in your expression and use the second parameter to set the format

hope that helps

Joe

[#4]

Hi joe,

i did'nt understand how to get that.

can u plz modify this attachment.

thanks

[Anonymous]

Like this :

[jagan · Accepted solution]

Hi,

Please check this attached file for solution.

Regards,

Jagan.

[rustyfishbones]