Webi Rich Client 4.1 - Round numbers to Kilo $ or Million $

[Former Member]

Hello all,

I have this chart (image attached) which has very high numbers (billions). I would like to round them to make it more clear.

For example : $ 42,000,000,000  --> M$ 42,000

I was not able to find a good solution, only to divide the numbers but the amounts are wrong then.

Thank you for reply in advance!!

[former_member59613]

Hi,

I think the easiest thing to do would be to use the Format Chart/Value Axis/Design option called:

Unit Scale Factor

Set this to "9" and it will change the value axis display to show the number in Billions. 

Then within the same section, you could set a Custom Format Pattern (under the Number heading at the bottom)

Using Pattern "# B" would display the number as

10 B

That should make it a little prettier.

[Former Member]

Hi,

try dividing your measure by 1,000,000,000 and use it on your chart

Cheers,

Rogerio

[Former Member]

Any ideas?

[TammyPowlas]

Moved to Web Intelligence space for faster response.