Hello,
The ultimate dataset in my macro has 2 header rows which are prepended using a Text Input tool, at which point the Filter Province is Null:
The subsequent rows are generated in the macro using a control parameter and filter loop, so each iteration through the loop, rows 3 onwards will all have the same Filter Province.
My goal is to backfill the Filter Province of the first 2 rows to match. I tried using a multi-row formula with [Filter Province + 1], but that only backfills row 2. I was thinking a formula, where if Filter Province is null, use an aggregate like "Last" or "Max", but can't identify the right operand.
Any suggestions are appreciated.
