6 Replies Latest reply on Jun 20, 2018 3:06 PM by Deepak Rai

    Aggregate and non-aggregate error

    Tony Smith

      Can someone please help me fix this formula to remove the error: "Cannot mix aggregate and non-aggregate comparisons or results in 'IF' expressions"


      I want to count the number of Order id without Columbus city include.


      No of Order w/o Columbus City

      IF [City] !='Columbus' THEN [No of Order] ELSE 0 END



      No of Order

      COUNT([Order ID])



      I have also attached a copy of the workbook to this message.