Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
and in demsion i have left(CLE,4)
So , the results is usually 0 with all CLE only 201711
May be try this
You cannot suppose to use degrade for 1 field like, Use this?
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)