6 Replies Latest reply on Sep 10, 2018 7:27 AM by ravi.sawhney

    Custom Calc Field Help

    ravi.sawhney

      Lets assume below is my invoice table for a given client. As invoice is generated it stamps a Sales Person to that order based on a lookup to another system

       

      Invoice #Date
      Sales Person
      110/1/18John
      212/3/18Jack
      310/9/18Jim

       

       

      I want to create a new column that stamps, for all invoice numbers, the last sales person associated with that account as show:

       

       

      Invoice #Date
      Sales Person
      Last Sales Person
      110/1/18JohnJim
      212/3/18JackJim
      310/9/18JimJim


      I am new to custom calc fields so appreciate some help.

       

      Thanks
      Rav