MULTI-ROW FORMULA PROBLEMS

[kpmg_lc_analyst]

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. 

[MarqueeCrew · Accepted 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

[kpmg_lc_analyst]

thank you. 

[MarqueeCrew]

You're welcome.  Glad to help.