4 Replies Latest reply: Jul 25, 2017 9:54 AM by Sunny Talwar RSS

    Lost customers

    Jacek Stypulkowski


      hope you can help,

      I'm looking for a number of lost customers comparing current year with previous year.


      The below expression seems to be working, but it is not. It returns null.


      count({<Year={'$(=max(Year)-1)'},[Customer Name]=E({<Year={'$(=max(Year))'}>}

      [Customer Name])>} distinct ([Customer Name]))


      Can you advise on this please?