Multi-row formula problem

[ck2019]

Hey guys

When I tried to run this as a multi-row formula to populate the scheme name into the scheme name column that appears above each measure condition, I couldn't get it to work.

I managed it through other convultated means, but I'd to understand what i was doing wrong so if someone has the time could then pop a solution into this thread please?

Measure	Prop'n	Scheme Name
May-14 PSP
BPBT	0.75
TSR	0.25
May-15 PSP
BPBTPS	0.75
TSR	0.25
May-16 PSP
BPBTPS	0.75
TSR	0.25
May-17 PSP
BPBTPS	0.75
TSR	0.25

to this: 

Measure	Prop'n	Scheme Name
BPBT	0.75	Jun-13 PSP
TSR	0.25	Jun-13 PSP
BPBT	0.75	May-14 PSP
TSR	0.25	May-14 PSP
BPBTPS	0.75	May-15 PSP
TSR	0.25	May-15 PSP
BPBTPS	0.75	May-16 PSP
TSR	0.25	May-16 PSP
BPBTPS	0.75	May-17 PSP
TSR	0.25	May-17 PSP

Thanks a lot!

[Emil_Kos · Accepted solution]

Hi @ck2019,

I have prepared a workflow for you:

[Qiu · Accepted solution]

@ck2019 
I feel a filter is needed.

[ck2019]

Thanks both - I knew I was being a bit silly with it and now see the light!

[Emil_Kos]

Hi @Qiu,

Good point with the filter. 😀

[Qiu]

@ck2019 
Thank you also.

@Emil_Kos 
It was only based on your flow.