Number format as K

[Anonymous]

Hi,

How can we convert numbers to K and M; (with HIDE AXIS on)

100.000 as 100 K

1.000.000 as 1 M

It happens when HIDE AXIS is off when when we take it off the numbers appear normally.

Thanks.

[sunny_talwar]

How are you formatting them? on Numbers tab of chart properties or within the expression itself?

[avinashelite · Accepted solution]

Try like this

=If(sum(Amount)/1000000000 > 1,Num(sum(Amount)/1000000000,'$#,###B'),

if(sum(Amount)/1000000>1,

Num(sum(Amount)/1000000,'$#,###M')

,

if(sum(Amount)/1000>1,Num(sum(Amount)/1000,'$#,###K')

)

)

[Anonymous]

I am using CHART expression,

But is there a way to do it with NUMBER tab not with formula.

thnks.

[Anonymous]

is there a way to do it with NUMBER tab not with formula.

thnks.

[sunny_talwar]

AFAIK no. I guess the issue is that with number tab it behave the way it is programmed, not much can be configured. But with Expression option you have greater flexibility.