0 Replies Latest reply: Nov 27, 2012 12:30 PM by Diego Monge Porras RSS

    Compare Names by Quarter and marked them as New or Existing

      Hello,

       

      I have to create a calculated field base on the original data.

       

      I have buyer names for several quarters, and I need to identify wheter it is a new buyer or an existing one by quarter.

       

      So the logic should be like this:

       

      Compare the Buyer Names for each Quarter, and compare them to the Buyer Names from the previous four Quarters.

       

      If the Name exists in the previous four Quarter then is and existing Buyer

      If the Name does not exists then it is a new Buyer

       

      Also I would like to know if this could be done in the script or as an expression...

       

      Thanks in advance for any help.