convert millions or billion

Anonymous — Sun, 22 Jan 2012 20:01:26 GMT

123451212121 to 12.3 mn

6123121212 to 6.0 mn

100000 to 0.1mn

swuehl — Sun, 22 Jan 2012 22:31:28 GMT

Maybe by just dividing your numbers by 1 Million or 1 Billion and adding an appropriate abbreviation?

=num(6123121212 / pow(10,9),'#.0') &' bn'

=num(6123121212 / pow(10,6),'#.0') &' mn'

More general for million conversion

=num(Value / pow(10,6),'#.0') &' mn'

and conversion to billion

=num(Value / pow(10,9),'#.0') &' bn'

In chart properties, number tab, you could also set million / billion symbols to convert your axis display.

Hope this helps,

Stefan

topic convert millions or billion in QlikView