Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

OBIEE 12c - incorrect grand total for ABS formula

Received Response
13
Views
2
Comments
User_BCACP
User_BCACP Rank 1 - Community Starter
in Oracle Analytics Cloud and Server

Hello,

I used ABS formula → abs(qty)

Results for individual records are ok, but Grand Total is incorrect.

For example:

image.png

In RPD I have set → Aggregation SUM.

What am I doing wrong?

Please help me.

Tagged:

Answers

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

    @User_BCACP -

    If you want the absolute value of the total sum, update the measure formula in RPD → Logical Column as: ABS(SUM(QTY)) from SUM(ABS(QTY)) and then validate.

    Hope this helps!

  • Gianni Ceresa
    Gianni Ceresa Mod
    edited Mar 12, 2025 9:47AM

    Hi,

    I would say that what you see is correct, even if not what you expected.

    You are facing a pre vs post aggregation behaviour: SUM(ABS(quantity)) <> ABS(SUM(quantity)).

    Is this a measure you need often? If yes, I would definitely add the ABS in the column mapping between the physical and the logical layer in the RPD, and make that ABS Quantity column available next to the default Quantity column in the logical model and subject area.

    I don't have an OBIEE 12c available, and in OAS 2025 is just does work as you would expect it (applying the expression before the aggregation).