3 Replies Latest reply on Aug 6, 2018 12:35 PM by Deepak Rai

    I get an error saying cannot mix aggregate or non-aggregate comparisions

    keerthi kumaran

      I am using below condition and in that condition [Sort Order] is (IF ([In top n?]) THEN 1 ELSE 2 END) and [Acct Num]  is one of my columns that has account name data in it. I get an order saying "cannot mix aggregate or non-aggregate comparisons", when I try to create a calculated field using the below logic.

       

      sum(IF [Sort Order] = 1 then [Acct Num]

      ELSE "OTHERS"

      END)

       

      Please let me know how to fix this