Oracle Fusion AI Data Platform Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Fusion AI Data Platform Forum› Oracle Fusion AI Data Platform Forum

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
11
Views
1
Comments
Stefano_Mazzocca
Stefano_Mazzocca Rank 6 - Analytics & AI Lead
in Oracle Fusion AI Data Platform Forum

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 & AI 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!