Skip to Content
avatar image
Former Member

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

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!! 😊

Capture.PNG (41.0 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Dec 30, 2014 at 10:36 AM

    Any ideas?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 30, 2014 at 02:22 PM

    Hi,

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

    Cheers,

    Rogerio

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 30, 2014 at 07:12 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded