Oracle Transactional Business Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Transactional Business Intelligence

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Scale a long number

Received Response
1
Views
2
Comments
Tonya H
Tonya H Rank 2 - Community Beginner
in Oracle Transactional Business Intelligence

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.

Answers

  • Nathan CCC
    Nathan CCC Rank 7 - Analytics Coach

    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
    Tonya H Rank 2 - Community Beginner

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