3 Replies Latest reply: Mar 27, 2012 9:21 AM by jenghardt RSS

    expression for "New Customer"

      Hi all,

      I'm looking for a expression where I get a COUNT of "New Customer" back. The definition of "New Customer" is as follow. Each customer, which buy a product in 2012 but NOT has bought it in 2011 is a "New Customer".

      Fields in my model:
      CustomerName
      Jahr (Year)
      Sales

      I tried it out with the following expression:
      COUNT({$<CustomerName = p({$<Jahr={2012}>} CustomerName) - p({$<Jahr={2011}>} CustomerName)>} CustomerName)

      I get values but it seems the number of customers are to low.

      Thanks for your help!

      Jürgen