OBIEE calculations — Oracle Analytics

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 calculations

Received Response
1
Views
2
Comments
user8591891
user8591891 Rank 1 - Community Starter
edited Aug 13, 2024 6:16PM in Oracle Analytics Cloud and Server

Hello All,

I have the below requirement we need to calculate Column 4, similarly we have to calculate for other values of column 1 (B, C, D) too

Please help me with the inputs, Thanks!

Header 1Header 2Header 3Header 4
Column 1Column 2Column 3Column 4
AGreenValue 1(Value 2 + Value 3)*100/ (Value 1 + Value 2 + Value 3)
ARedValue 2
AYellowValue 3

Regards,

Pavan

Answers

  • choracy69
    choracy69 Rank 6 - Analytics Lead

    Hi,

    I think that you should use FILTER in your formule.

    For example:

    If you want show value on first row you can add something like that:CASE WHEN Column 2 = Green THEN .... END

    Next you create formule, maybe something like that:

    ( FILTER(COLUMN 2 USING (COLUMN 2 = RED)) + FILTER(COLUMN 2 USING (COLUMN 2 = YELLOW)) ) * 100 / ( FILTER(COLUMN 2 USING (COLUMN 2 = GREEN)) + FILTER(COLUMN 2 USING (COLUMN 2 = RED)) + FILTER(COLUMN 2 USING (COLUMN 2 = YELLO)) )

  • Gianni Ceresa
    Gianni Ceresa Mod

    Hi,

    It will of course depend on how your model looks like but you can also play on hierarchies levels etc.