Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forum› Oracle Analytics Forum

Categories

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

Display Measure values when contain negative value

Received Response
221
Views
12
Comments
2»

Answers

  • User_JL3CW
    User_JL3CW Rank 6 - Analytics & AI Lead

    HI all,

    In rows i have the following columns.

    pastedImage_0.png

    I am unable to understand how to have a FLAG at row level to check if there is a single negative value for any period then display the whole row. Please suggest.

    Regards,

    Chandra.

  • Joel Acha
    Joel Acha Rank 8 - Analytics & AI Strategist

    @Gianni Ceresa has already suggested that you use the SUM of the Absolute of the measure to compare against the SUM of the measure by whatever you're aggregating in your table. If the SUM of your measure is different from the SUM of Absolute components then you know the row has at least a negative record. This can be used to set flag at row level of your table.