Hello everybody,
I want to build a tab wich contains the Dimension portfolios (PTF)
but I'd like to fetch only the ones which reply to the request below.
I tried by using the Set Analysis. But I failed. I think I'm not so far.
Could you drive me ?
I only wan't to select PTF(PTF_Libellé) which reply to
PTF_type=OPC and CtrValo
PTF_Statut=Actif...etc....
Here's my set construction below :
=if(match(PTF_Libellé,PTF_Type={'OPC','CtrValo'},
PTF_Statut={'Actif'},
[PTF_Classe d'actif]={'Actions'},
ZE_PTF_ANA_ENTITE_TYPE={'Portefeuille'},
PTF_CLS_Type={'Sous-composite GIPS'},
[PTF_CLS_Libellé classification]={'Euro Equity','Euro SRI Equity','France Equity'},null(),PTF_Libellé)
Thank you for your help
