set analysis with function

[souadouert]

Hello,

i have this problem with this set expression(table)
sum({<CLE,CLE= {"=Left(CLE,4) = '2017'"} ,CLE= {"=mid(CLE,5,2) = '11'"}, COMPTE_TYPE_DEPOT-={"AUTRES SOMMES DUES","CARTE","-","DEPOTS BANQUES DINARS"}>}COMPTE_SOLDE_COMPTABLE_TND)

and in demsion i have left(CLE,4)

So , the results is usually 0 with all CLE only 201711

[sunny_talwar]

May be try this

Sum({<CLE= {"=Left(CLE,4) = '2017' and mid(CLE,5,2) = '11' "}, COMPTE_TYPE_DEPOT -= {"AUTRES SOMMES DUES","CARTE","-","DEPOTS BANQUES DINARS"}>} COMPTE_SOLDE_COMPTABLE_TND)

[Anil_Babu_Samineni]

You cannot suppose to use degrade for 1 field like, Use this?

Sum({<CLE= {"=Left(CLE,4) = '2017' and mid(CLE,5,2) = '11' "}, COMPTE_TYPE_DEPOT -= {"AUTRES SOMMES DUES","CARTE","-","DEPOTS BANQUES DINARS"}>} COMPTE_SOLDE_COMPTABLE_TND)

[sunny_talwar]

I think what you really need is to ignore CLE in your inner expression....

Sum(TOTAL {<CLE= {"=Left(Only({<CLE>}CLE), 6) = '201711' "}, COMPTE_TYPE_DEPOT -= {"AUTRES SOMMES DUES", "CARTE", "-", "DEPOTS BANQUES DINARS"}>} COMPTE_SOLDE_COMPTABLE_TND)