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

Display Measure values when contain negative value

Received Response
181
Views
12
Comments
2»

Answers

  • User_JL3CW
    User_JL3CW Rank 6 - Analytics 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
    Joel Rank 8 - Analytics 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.