Multi Filed Formula?

[G_SAND]

Hi.

I have managed to use a multi field formula calculate some figures but I want them in a different row. In the table below I have added the Field 2 data together for each sequence where a 3 is proceeded by a 4. So the first line here is 0 because the 3 doesn't have a 4 after it, then 77 + 308 = 385 and so on. But I want the calculated data to appear against the 3

Start                               Calculated           Wanted

Field 1	Field 2		NewField		NewField
3	184		0		0
3	77		0		385
4	308		385		0
3	61		0		246
4	185		246		0
3	62		0		370
4	308		370		0

Any help would be great.

Thanks

[Kenda · Accepted solution]

Hey @G_SAND! Try just using a Multi-Row Formula tool. I would create a new field with the following expression:

iif([Field1]=3 && [Row+1:Field1]=4,[Field2]+[Row+1:Field2],0)

Hope this helps!

[G_SAND]

Thanks @Kenda

For some reason the 'Row+1' option for the new field wasn't in the selection which I though was strange so I logged out and back in again and it appeared.

I did manage to work out how to get there in the end, but your method looks better!!