Multi-row increasing values

[EL1988]

Hi all,

I have the ID and Condition columns, and I am now trying to generate the Output column using the Multi-row function. I am able to generate the Output Column using a basic IF THEN formula, but can't get it to increase. 

What would be the best way of going about doing this?

Thank you.

ID	Condition	Output
101
101	Y	101Text_1
101	Y	101Text_2
101
101	Y	101Text_3
101
102
102	Y	102Text_1
102	Y	102Text_2
102

[AngelosPachis · Accepted solution]

Hi @EL1988 ,

Here's one way you can do it. I would isolate the records that have a condition and based on those I generated a count per ID. The you can form the output text and bring the two streams back together.

Hope that helps,

Angelos

[EL1988]

Thanks Angelos. This works perfectly.