MULTI-ROW FORMULA PROBLEMS

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.

Parse

Common Use Cases

Preparation

Accepted answers

MarqueeCrew

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

All comments

MarqueeCrew

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

kpmg_lc_analyst

thank you.

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703