9 Replies Latest reply on Mar 2, 2017 2:45 PM by Tom W

    Please fix this If statement

    Radi Saran

      if

      year([Submit_Date]) > 2017

      AND [Status] != "INACTIVE"

      AND ([Industry]) != "CELL_PHONES"

      and [Industry] != "JEWELRY"          

      and [Industry] != "CAR_AUDIO"

      and [Industry] != "SCOOTERS"

      and [Industry] != "ELECTRONICS"

      THEN COUNTD([Merchant ID])

      END

       

      I get the error saying that " Cannot mix aggregate and non aggregate functions"