22 Replies Latest reply: Oct 16, 2017 7:26 AM by Sunny Talwar RSS

    New Customer and Dead Customer between Max Year and previous Years

    Ghassan AlDalati

      Hi All... Please help me.

      I am create ListBox for New Customer have sales in max selected Years and have no Sales in previous Years from Years selected Rang

      if I select Year 2014 - 2015 - 2016 - 2017 and I want to show only the new 2017 customer with sales amount

      " =if(sum({$<Year={"$(=max(Year))"}>}Sales)=0 and sum(Sales)>0  then show me the new customers with sales amount "



      also I need to create another customer list for dead costumes have sales in previous years and have no sales in max year


      please help me how to use IF statement in my expression .


      Thank;s and regards