Syntax problem trying to use Row-1

[MarshallG]

Hi all-

Can you please help me troubleshoot my syntax below. I am trying to fill null values with the previous row's value using the Multi-Field Formula tool and am getting a formula error of "Unknown variable...".

if IsNull( [_CurrentField_] )

then ([Row-1:_CurrentField_] )

else [_CurrentField_]

endif

Thanks!

[chris_love · Accepted solution]

Hi

I'm afraid you can only use Row-1 in Multi-row formula. Not multi-field.

If you need multi-field over multiple rows then there are a few posts
already on the forum on that subject. I wont search for them as I'm sure
you will br able to find them - they were well titled.

Chris

[MarshallG]

Got it. Thanks!