3 Replies Latest reply on Feb 22, 2018 2:50 AM by Ankit Goyal

    Lookup on String

    Ankit Goyal

      Hey guys,

       

      I need some help while doing Lookup on a string. Tried multiple ways :

       

      1. by assigning a number

      2. doing a running sum

      3. comparing running sum to lookup (running sum, -1)

      4. if #3 is TRUE then trying to call previous status..

       

      This is what I want:

       

      If Project Status is Yellow or Red and following month is NULL then carry the same status as previous else do nothing.

       

      Thanks in advance!