Multi-row formula tool error

[NBPSE]

I am trying to replace all the [Null] values in a column with the only number in the column using the multi-row formula tool, but the values are not updating. How can I update all Null values with my single number in the column?

IF ISNULL([Value])
THEN [Row+1: Value]
ELSE [Value] ENDIF

[griffinwelsh · Accepted solution]

Sort the single value to the top before the multi row formula. Then use the below formula:

IF ISNULL([Value])
THEN [Row-1: Value]
ELSE [Value] ENDIF

[apathetichell]

use a filter tool - filter for the non-null value. append the value back to datastream. This isn't a situation where you'd use a multi-row formula.

[Qiu · Accepted solution]

@NBPSE 
Multi-Row Formula tool can only do downward calculation. so we have reverse the dataset first to bring the number on top.

[NBPSE]

This worked, thank you!