3 Replies Latest reply on Feb 2, 2018 2:36 PM by Wes Reneau

    Issues with formula

    Ganesan  karuppasamy

      My data set looks like below and i want to write a calculation to populate the x as returning customer since he ordered on 16-17 and 17-18 and y as lost and z as new customer. Due to the values for different year getting populated in different rows i am getting null as result for all the three customers. Did any one face this scenario before?

       

      Appreciate your help !

        

      Customer Name                         Amount
      X16-1717-18
      20,000
      15000
      Y50000
      0
      Z0
      12000

       

       

      Thanks,

      Ganesan k.