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")


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


      It gives error saying cannot mix aggregate and non aggregate.


      Kindly Help