Oracle Analytics Cloud and Server

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

  • 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.

  • 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.

Welcome!

It looks like you're new here. Sign in or register to get started.