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

Is there a way to get the difference between 2 rows as a Grand Total

Received Response
9
Views
1
Comments
SharonAtGorilla
SharonAtGorilla Rank 3 - Community Apprentice
in Oracle Fusion Data Intelligence

I know that the msum function can get that, but I need to display it as a column total not another column.
For instance using the Financials -GL Balance Sheet Subject Area and using Fiscal year

Fiscal Year #Cash
2024 50,000
2025 48,000
Grand Total 2,000

Answers

  • RVohra
    RVohra Rank 7 - Analytics & AI Coach

    Can you see if you can use following formula in a new measure :

    CASE
    WHEN GROUPING("Fiscal Calendar"."Fiscal Year") = 1 THEN
    MAX("Balances"."Ending Balance")
    - MIN("Balances"."Ending Balance")
    ELSE
    "Balances"."Ending Balance"
    END