Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
We have a number of portfolios and I would like to limit the portfolios to those starting with code '125'
I think wildmatch is the way to go but am not 100% sure.
sum({$<period = {">=$(vStartPeriod_CY)<=$(vEndPeriod_CY)"},
account = {1101,1201,1301,1401}, portfolio = {wildmatch(portfolio,'125*')>0)}
>} GBP)
I have tried a few different variations of the code above but am struggling.
Could someone please suggest the way to do this.
Many thanks
Paul
sum({$<period = {">=$(vStartPeriod_CY)<=$(vEndPeriod_CY)"},
account = {1101,1201,1301,1401}, portfolio = {'125*'}
>} GBP)
sum({$<period = {">=$(vStartPeriod_CY)<=$(vEndPeriod_CY)"},
account = {1101,1201,1301,1401}, portfolio = {'125*'}
>} GBP)
Thanks, I guess I was over complicating it!