Use of Wildmatch in expression

[paul_ripley]

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

[Kushal_Chawda · Accepted solution]

sum({$<period = {">=$(vStartPeriod_CY)<=$(vEndPeriod_CY)"},

account = {1101,1201,1301,1401}, portfolio = {'125*'}

>}  GBP)

[paul_ripley]

Thanks, I guess I was over complicating it!