3 Replies Latest reply on Apr 8, 2016 10:31 AM by ankit.ravi

    Average between 2 columns


      I want to find the average of Control Seg1 and Control Seg2 , then compare it with Test Segment.
      So what I trying to display is :

      if avg(Control seg1 and Control Seg2) > Test Segment then 1

      else 2


      The measure is Sum of Ad_Revenue.


      So, can  someone help me with this situation.