8 Replies Latest reply on Jul 21, 2018 5:49 AM by Tony Smith

    Cannot mix aggregate and non-aggregate arguments

    Tony Smith

      Hi All.

       

      I am getting "Cannot mix aggregate and non-aggregate arguments" errors when I tried creating the code below.

       

      Current Year Orders

      IF [BBCA Fiscal year]='19' THEN [No of Orders] END

       

      Current Year RCP

      IF [BBCA Fiscal year]='19' THEN [RCP] END

       

      Any help on this would be much appreciated

       

      Thanks

       

      Regards

      Tony