Help on a solution

[Naga]

Hi All,

I need help in deriving the below output. I tried using multi row formula, however, it did not resolved. Somehow, I am missing something on it.

Field1	Field 2	Output
SI	1	SI01
SI	1	SI02
SI	1	SI03
BI	0
SI	1	SI04
SI	1	SI05
BI	0

Thanks
Naga

[Qiu · Accepted solution]

@Naga 

Something like this?

[Emil_Kos · Accepted solution]

Hi @Naga,

I have prepared a workflow for you:

And the output:

[atcodedog05]

Hi @Naga 

Here is how you can solve with a mult-row formula tool.

Steps

1. Using multirow formula tool to create running total (ID)

2. Using formula to output SI01 if field is not 0, if 0 then null

Hope this helps 🙂 Feel to ask if you have any questions