3 Replies Latest reply on Jun 25, 2018 2:56 PM by Tony Smith

    Cannot mix aggregate and non-aggregate arguments / comparisons

    Tony Smith

      Hi

       

      I am getting "Cannot mix aggregate and non-aggregate arguments with this function" when I tried to divide price with Host excluding Loft. Please see screenshot below

        

      Price

      Price.png

       

      Host excluding Loft

       

      This formula is work

       

      Host excluding Loft.png

       

      DSD

       

      I got an error message when I tried to divide price with Host excluding Loft

      DSD.png

       

       

      Any help on this would be much appreciated

       

      Regards

      Tony