Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I wanted to display money in terms of K.
Ex: I have data like this 1000000 should be represented as 1000k
can anyone suggest how to do this? or any better alternative since number of zero's creates confusion
Regards,
Prajna
Here you go, Very simple...
Just use this in Max 10000/1000 and K in Number Tab....
where you want to display, in which control..
if you want to display in chart.. see the image below..
On Number tab, right >> down..
hi,
I want to achieve in gauge chart...
I tried this it didn't work out
Regards,
Prajna
Use like below:
=Num(YourExpression / 100,'##.##K')
are you showing this in "Text in Chart" or ???
hi,
Its nothing but min and max value in the gauge..
As shown in the above attached image.. wecan see some values rite? so that is the values given in as below
Hi,
On Number tab, set it fix to 0, and add K, see image
Result Below, But dont forget to Devide your Expression by 100
Here you go, Very simple...
Just use this in Max 10000/1000 and K in Number Tab....
Thank you
Regards,
Prajna
was very simple, but you did not explain it first, as you show image in last post.
any way...