Scale a long number

Tonya H

I have a horizontal bar chart showing a long dollar figure (billions) and would like to scale it down it to $#.#B. I know this can be done for a tile but cannot determine how to show the label with an abbreviated value on a chart.

I've tried the ROUND function and no luck.

Any suggestions would be appreciated.

Thanks.

Nathan CCC

Hi,

Use division. If x is amount in unit of currency then add a calculated column with formula x/1000000 is millions etc. then use the calculated column in your chart.

Tonya H

Ah…clever. Didn't think to do that! Thank you for responding!