Number Formatting

[sampada0810]

I want to format the number in 'K' and 'M' depending on the values.

I am taking values into a text box.

Please find the screen shot attached.

[Anonymous]

I would suggest you use a KPI object instead you can set the number formatting to get and you will get the k or m

[lakshmikandh · Accepted solution]

Try something like this

if(sum(value)/1000000000>1 , num(sum(value)/1000000000,'#,##0 B'),

if(sum(value)/1000000>1 , num(sum(value)/1000000,'#,##0 M'),

if(sum(value)/1000>1 , num(sum(value)/1000,'#,##0 K'),

num(sum(value),'#,##0'))))

[rupamjyotidas]

Sorry , Can't help you for K or B in text box, the above solutions works fine, if you are ready to compromise.

[sampada0810]

This Works.

I took my expression into a variable and then applied this if statement.

Thanks !