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!