Help with Multi-Row Formula

[Tristan]

Hello,

Currently having an issue with a multi-row formula, I'm looking at the regional changes of the trucks and I would like the regional count to increase every time the region changes for each truck, as per the example in the excel document highlighted in yellow.

Many thanks for your help in advance,

Regards,

Tristan & Iain

[JohnJPS]

Group by NAME, and try a formula like this:

IIF([REGION] == [Row-1:REGION],[Row-1:SomeNewField],[Row-1:SomeNewField]+1)

... where I'm creating [someNewField] in my formula.

Grouping on Name will get you the re-numbering by name; and the above formula increments each time the region changes.

Hope that helps!

John

[rarmstrong · Accepted solution]

You can try this

[Tristan]

Many thanks for your responses - you've solved our problem!

Thanks,

Tristan