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

    Average between 2 columns

    ankit.ravi

      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.

       

      Thanks

      Ankit