Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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')
)
)
How are you formatting them? on Numbers tab of chart properties or within the expression itself?
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')
)
)
I am using CHART expression,
But is there a way to do it with NUMBER tab not with formula.
thnks.
is there a way to do it with NUMBER tab not with formula.
thnks.
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.