sum if max problem

Tue, 30 May 2017 13:45:54 GMT

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:

Date	Product	Sales	Last day sales
25/5/2017	Apple	25k$	0$
25/5/2017	Bananas	30k$	0$
28/5/2017	Oranges	65k$	65k$
28/5/2017	Apple	21k$	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

Re: sum if max problem

sunny_talwar — Tue, 30 May 2017 13:48:57 GMT

May be this

Sum(Aggr(If(Date = Max(TOTAL <Product> Date), Sales), Product, Date))

Tue, 06 Jun 2017 13:42:42 GMT

it works, thanks a lot Sunny