Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have many fields : N° of order , costumer , order date , delevery date , ammount .
I need to make : if delevery date - order date > 3 month then make the sum ammount for the N° of order else null .
But I ve try to make if ((interval delevery date - order date ) >3 ),sum ammount ,0)
but it's a big fail xD
Can you help me ?
Hi @Louveduval
Perhaps something like this
=Sum(If((Year([DelIvery Date])-Year([Order Date]))*12+13-Month([Order Date])-(12-Month([DelIvery Date])) > 3, Amount, 0))
Hi @Louveduval
Perhaps something like this
=Sum(If((Year([DelIvery Date])-Year([Order Date]))*12+13-Month([Order Date])-(12-Month([DelIvery Date])) > 3, Amount, 0))
sadly it doesn't work
You should provide a sample of data as well as the expected outcome.
It was a mistake form my part , I've used the bad filter dd/MM/YYYY and not MM/YYYY