Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi i am trying to achieve the following if a customer has bought something the last two years then active if hasnt then inactive
i have the following statement but it is not working as i assumed;
if(Year > max(Year-2),
if(Sum($(vNettoFsg)) > 0, Count(Customer))
please advise.
Best,
Brad
Hi.
I would propose that you do this check in the reload script. If it is not possible, please attach a sample application so that I can try on that.
Ioannis.
Hi,
you can use nested set analysis.
Try something like this,
count({<Customer={"=sum({<Year={'>=$(=max(Year)-2)"}>}Sales)>0"}>}Customer)