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!
4 answers
Good morning - see below
this is the formula
ifnull(lookup(attr([Status]),0),PREVIOUS_VALUE(attr([Status])))
Jim
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
