Simple Conditional Formula

[mattcoleman]

This seems like it should be easy to do, but I can't figure it out. I'm trying to identify runs by looking at a field called 'STEP'.

I used a Multi-Row tool for 'STEP-1' which looks at the previous step value. When 'STEP-1' = 0 and 'STEP' > 0, it's a new run and I want a new column to start with '1' as the run. The next time the test passes (goes from 0 to a non-zero number), I want run '2' listed, which would be the current value + 1.

When I try and reference the Output Column (Step_Test) in the formula tool, it gives me an Unknown Variable error.

[atcodedog05 · Accepted solution]

Hi @mattcoleman 

Sorry, my bad updated it.

Workflow:

Hope this helps : )

[mattcoleman]

Many thanks, that worked!!!!

[atcodedog05]

Happy to help : ) @mattcoleman 

Cheers and have a nice day!