Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
1000000000->1.0 bn
Hi,
In the number properties of the expression in the chart, add the text "bn" under the "Billion Symbol" setting.
Regards,
Stephen
how to set 1.0 for 100000000
If you use in a chart, look for tab "number" and put the symbol for bn. Or divide the quantity by a billion
i already divide by billion but the result is wrong
It really depends on where you are showing it.
I might try one of these:
Num(Sum(Sales)/1000000000, '#,##0.0')
-> 2.645 bn will show as 2.6
Num(Round(Sum(Sales)/1000000000, 1), '#,##0.0')
-> 2.645 bn will show as 3.0
Num(Floor(Sum(Sales)/1000000000, 1), '#,##0.0')
-> 2.645 bn will show as 2.0
Like I said, it depends where you need to display it.
=Num(2584580000/1000000000,'#,###.0000bn')
