Long numbers to Short Numbers

[Syahfira1]

Hi,

How I can convert long numbers to short numbers like to 2 significant figures?

I have long numbers in billion, and I would like to make it short and show in 2 decimal place only.

The numbers are long as in the image I attached. Aim is to make it simple readable number.

For example :

From this 364636348.06 to this 3.64 M

Is this possible? 

And how I can change the billion numbers to million and thousands but making the number look short and simple instead of long numbers?

[Digvijay_Singh]

Try this method, replace your expression with sum(value) - 

dual(num(sum(Value)/pow(10,3*floor(log10(sum(Value))/3)),'#,###.#'&pick(floor(log10(sum(Value))/3),'K','M','B')),sum(Value))

https://community.qlik.com/t5/New-to-Qlik-Sense/Number-Formatting-issue-while-changing-billions-Mill...

[Syahfira1 · Accepted solution]

Hi,

The solution suggested doesnt fulfill what Im looking for. 

At the end, I just divide my calculations by 1 billion and standardize all the charts to display numbers in billions only with 2 d.p

Thank you.