Multi-row formula tool error

Question

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

rows.png

griffinwelsh · Accepted Answer

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

Qiu · Accepted Answer

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