2 Replies Latest reply: Jun 6, 2017 9:42 AM by Nicoals Martin RSS

    sum if max problem

    Nicoals Martin

      Hello all,

       

      I would like to have the sum of the last day sales only, but I have a aggr error.

       

       

      I have the folowing formula for the last day value:

      if(max(total Date) = max(Date) and count(distinct Date)=1, [Sales(K$)],0)


      with the following result:


      DateProductSalesLast day sales
      25/5/2017Apple25k$0$
      25/5/2017Bananas30k$0$
      28/5/2017Oranges65k$65k$
      28/5/2017Apple21k$21k$


      The result expected is merely the sum of the last day sales, but it doesn't work:


      sum(if(max(total Date) = max(Date) and count(distinct Date)=1, [Sales(K$)],0))

      error: Nested aggregation not allowed

       

      Could you please help?

       

      Thanks in advance,

       

      Nicolas