How do I "copy down" using the multi-row formula? I have one value that I want to apply to successive null fields in succeeding rows. I want Rows 2-5 to be '017' and row 7 to be '088'.
Row 1: 017
Row 2: [Null]
Row 3: [Null]
Row 4: [Null]
Row 5 [Null]
Row 6: 088
Row 7: [Null]
Thanks.
Solved! Go to Solution.
IIF(isnull([Field1]),[Row-1:Field1],[Field1])
If your current row for this field is NULL, then use the prior row value for the field.
That should do the trick (after you rename Field1 to being your fieldname.
Cheers,
Mark
thank you.
You're welcome. Glad to help.