4 Replies Latest reply on Apr 19, 2018 2:59 AM by Charles Prodon

    Cannot mix aggregate and non-aggregate

    Charles Prodon



      I have a list of invoices with payment date and I am willing to count the number of documents that have a payment date in the most recent  month of the list.

      I have tried the following:

      COUNT(if month([Payment date]) = month(max([Payment date])) THEN [SAP doc number] END)


      Please help.