count the number of customers who purchased goods this year more than last year

[ariafc71]

dear community

i want  to count the number of customers whopurchased goods this  year more  than  last  year 

i  try  this  expression  ( kpi)

Count({<CustomerCode={"=Sum({<year={$(v_maxyear)}>}NetoSum)>Sum({<year={$(vprevyear)}>}NetoSum") >}distinct CustomerCode)

unfortunately it doesnt work

thanks for  help

ariafc71

[vinieme12]

Verify if your variables are evaluating correctly

OR try

=Count({<CustomerCode={"=Sum({<year={"$(=Max(Year))"}>}NetoSum)>Sum({<year={"$(=Max(Year)-1)"}>}NetoSum)" >}distinct CustomerCode)

[khaoulaaa]

Hello @ariafc71 

just a few modifications in the set analysis syntax 

=count({<CustomerCode={"=sum({<year={'$(v_maxyear)'}>}NetoSum) > sum({<year={'$(vprevyear)'}>}NetoSum)"}>} distinct CustomerCode)