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

    Lost customers

    Jacek Stypulkowski

      Hi,

      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?

       

      regards

      Jacek