Multi Row Formula Error

[ethankutch]

Hello,

I am trying to have a field called External ID's be the same for each row until it hits a new External ID.

I tried using the Multirow formula : IF IsNull([External ID]) THEN [Row-1:External ID] ELSE [External ID] ENDIF

However this expression ends up changing F1 into the same value as External ID and leaving Null values the same.

Does anyone know how to solve this?

I have attached a picture with highlights for context.

Thanks!

[geraldo]

@ethankutch 

the result is coming out in this field. and it would be better to change it to null

[Qiu · Accepted solution]

@ethankutch 
I can see a few thing we should change

1. The data type for your new field is Int32, and we should change it to String type

2. In your expression, you are not involving the "New Field" so take Row#5 as example, it is null so it will take value from row#4, which is still Null.

  A quick sample for your reference.