This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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:
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.