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!
Solved! Go to Solution.
@ck2024
I feel a filter is needed.
Thanks both - I knew I was being a bit silly with it and now see the light!