Oracle Fusion Data Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Fusion Data Intelligence› Oracle Fusion Data Intelligence

Categories

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

Why this division doesn't work?

Accepted answer
12
Views
1
Comments
Stefano_Mazzocca
Stefano_Mazzocca Rank 6 - Analytics Lead
in Oracle Fusion Data Intelligence

I have these yellow key metrics:

image.png

Why the green calculation, which is simply a division between the 2, always returns 0?

Tagged:

Best Answer

  • Sumanth V -Oracle
    Sumanth V -Oracle Rank 8 - Analytics Strategist
    Answer ✓

    @Stefano_Mazzocca - If the output of column 1 is column2/column3 then probably it's rounding off to 0. Kindly share the logical SQL of the workbook or the formula used for calculation of column1 to confirm. Thank you!