3 Replies Latest reply on May 17, 2017 12:14 PM by Lillian Aj

    Determining Order Status Using Prior Order Date as Marker

    Sandi Fanakos

      I am trying to calculate the "PRIOR" order date in order to determine if a customer is New, Regained or Active.   I am using the Lookup function to try and achieve that however it is not so effective with me using a "ATTR" aggregation in the formula.  Can anyone help me to refine this calculation so that I can see for each customer their prior order date (to the last order date)?

       

      Please see workbook attached.