Active Customer Calculation

[#1]

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

[giakoum]

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.

[#3]

Hi,

you can use nested set analysis.

Try something like this,

count({<Customer={"=sum({<Year={'>=$(=max(Year)-2)"}>}Sales)>0"}>}Customer)