I have a dataset where I'd like to increment the value by 1 in the column "Box" based on the previous value when it is not null. I've tried using a Multi-Row Formula tool with the parameters listed below, but the result is always still a null value.
Update Existing Field: Box
Num Rows: 1; Set Values to Closest Valid Row (also tried NULL and 0 or Empty)
Expression: if isnull([Box]) then [Row-1:Box]+1 else [Box] endif
I've also checked that the Box column is a Double type, not sure what else I'm missing! Thanks in advance for any ideas you might have!