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.
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
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'),
I took my expression into a variable and then applied this if statement.
Sorry , Can't help you for K or B in text box, the above solutions works fine, if you are ready to compromise.
Retrieving data ...