Help on a solution

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.

Thanks
Naga

Help

Accepted answers

Something like this?

I have prepared a workflow for you:

And the output:

Something like this?

I have prepared a workflow for you:

And the output:

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