9 Replies Latest reply on Feb 16, 2017 12:10 AM by sneha simha

    I have two fields sales and Quantity.

    sneha simha

      Dear All

       

      I created a calculated field named  UCP and the formula being (sum(Sales)/sum(Quantity)).

       

                 But when i try to use this formula

      if [Docdate]>=DATE(STR(if MONTH(TODAY()-1)>3

      then YEAR(TODAY()-1) else YEAR(TODAY()-1)-1 end)+"-04-01")

      and

      [Docdate]<=TODAY()-1 then [UCP] end

       

      It gives error saying cannot mix aggregate and non aggregate.

       

      Kindly Help

       

      Regards

      Sneha