Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I have set up a variable vInvTrusts that contains a list of values - see below
=match(portfolio ,'02502028','088000313','012700003','088300009','02505011','EX2000','IC2000')
I then want to use this variable in set analysis so I can exclude these values from the dataset.
I have tried the below but this doest exclude anything - what am I doing wrong
sum({$ <period = {">=$(vStartPeriod_CY)<=$(vEndPeriod_CY)"} , pl = {F01}, DataSource = {Agresso}, entity = {0005,0010,0011,0177,0348,0502,0002,0413,0522},portfolio -= {$(vInvTrusts)} >} IS_Investment_GBP )*-1
Many thanks Paul
No, not with such function, at least not with this kind of syntax - it was meant just as a list of strings.
- Marcus
If your variable contained:
'02502028','088000313','012700003','088300009','02505011','EX2000','IC2000'
it should work.
- Marcus
Hi Marcus
The variable vInvTrust I set up as below
So you think it should work?
=match(portfolio ,'02502028','088000313','012700003','088300009','02505011','EX2000','IC2000')
No, not with such function, at least not with this kind of syntax - it was meant just as a list of strings.
- Marcus