3 Replies Latest reply: Dec 14, 2017 11:47 AM by Sunny Talwar

set analysis with function

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

• Re: set analysis with function

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)
• Re: set analysis with function

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)
• Re: set analysis with function

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)