Hi,
I have a business requirement where i have to create a flag which iterates based on a specific task name and all the following tasks should have the same iterated value for the flag.
ID | Task Name | Flag |
1 | Creation | 0 |
2 | Check | 0 |
3 | Creation | 0 |
4 | Check | 0 |
5 | REVIEW | 1 |
6 | Creation | 1 |
7 | Check | 1 |
8 | Creation | 1 |
9 | Check | 1 |
10 | Creation | 1 |
11 | Check | 1 |
12 | REVIEW | 2 |
13 | Creation | 2 |
14 | Check | 2 |
In the above example, i need the flag to iterate based on the field REVIEW and all other following tasks till the next REVIEW task should have the same Flag value.
Kindly help me in resolving this Problem.
Regards,
Arjun