Multi-Row formula tool to fill up the way

[JamesG2806]

Multi-Row formula tool to fill up the way, So i have attached the spreadsheet so I want the following to fill up the way rather then down. If I use te below formula I know it will fill down till it stops seeing Null. 

IF IsNull([Currency]) THEN [Row-1:Currency] ELSE [Currency] ENDIF

But when I use this statement below it only fill's up by one line. Any chance someone could show what I am doing wrong

IF IsNull([Currency]) THEN [Row+1:Currency] ELSE [Currency] ENDIF

[danilang · Accepted solution]

Hi @JamesG2806 

The multi-row tool always goes from the top to the bottom.  If you need to go from the bottom to the top, add a RecordID and sort by this recordID descending.   This reverses the order of your records.  Use a Multi-row to fill in what you need and then sort by recordID ascending to get the original order back.

Dan 

[JamesG2806]

Perfect thanks for that