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.

       

      Thanks

       

      Regards

      Tony