2 Replies Latest reply on Apr 30, 2018 1:04 PM by Jieliang He

    Compare values with its average

    Jieliang He

      IF SUM([Click Rate])<WINDOW_AVG(SUM([Click Rate])) THEN 'high'

      ELSE 'low'

      END

       

      I wrote such a script to compare the value of a column with its average. But all the return is 'low'. Why is that?