Oracle Fusion AI Data Platform Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› 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!