Numbering

[#1]

Displaying  to show numbers in Millions ---'M'  and billions-----'B' and in thosands like  -'k',plz explain the expression

[sudeepkm]

Chart properties > Number

[sudeepkm]

another approach would be to use DUAL function.

In the Script:

set hideprefix = '_';

LOAD dual(fig,num) as _val;

Load * inline [

num,fig

1000,K

1000000,M

1000000000,B

];

Then in the UI: whenever user selects either K or M or B then the expression will change amount accordingly.

[#4]

thank you sudeep for your answer thank you so much,i will ask one more doubt plz explain