Hi all - I think this is an easy one, but I just can't find the right syntax or way way to write this formula. I have transaction data at the plan# level and sometimes the plan# is not included in the file, but it is always grouped by plan and if I look to the previous transaction I can find the # and I need to capture it.
My data occasionally will come down like this:
| Record # | Plan # |
| 1 | 12345 |
| 2 | |
| 3 | |
| 4 | 12345 |
5 | 12345 |
6 | 98765 |
7 | 98765 |
I wrote the following expression,
IF IsNull([Plan #])
THEN [Row-1:Plan #]
ELSE [Plan #]
ENDIF
But my result is only providing a value Record #2, but not repeating to number 3. I assume it is because the calculation is being applied to 2 and 3 at the same time, and since 2 isn't solved, it can't solve 3. I am sure there is something else I need to put in but I'm so new at this type of work I can't figure it out.
