Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a customer base on orders of 36 months of purchase.I wanted to know if we could from a period of date to verify if this same customer has already ordered over the last 24 months to know if It is a new or old customer to subsequently caculate a number of old and new customers
thanks for your help
Hi,
May be like in attached file
Regards,
Andrey
Hi,
Thanks for your help
This is practically that but why does not it work when I select a date and more it is possible to get at the end only two figures. A separate discount from customers for old and another for new?
regards
Hello, I wanted to thank you for your help not looking with your track I found a solution
New client=>301 = Sum(If(Aggr(Min({<Date=>} Date), [Code Client]) < AddMonths(vDateDébut,-24), 1, 0))