23 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

always the same result sunny

• Re: set analysis with function

What is the problem with this result... it met your condition where the first 4 of CLE is 2017 and the next 2 is 11?

• Re: set analysis with function

in 20171208 i have to have 5 708 324 466

• Re: set analysis with function

Then may be this

Sum({<CLE= {"=Left(CLE,4) = '2017' and Match(Mid(CLE,5,2), '11', '12') "}, COMPTE_TYPE_DEPOT -= {"AUTRES SOMMES DUES","CARTE","-","DEPOTS BANQUES DINARS"}>} COMPTE_SOLDE_COMPTABLE_TND)
• Re: set analysis with function

sunny,

I need to display in front of each cle the total of left

cle = 201711

• Re: set analysis with function

Got it, try this

Sum(TOTAL {<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

WITH THIS EXEMPLE MAY YOU UNTRSTAND  ME

• Re: set analysis with function

Did you try this?

Sum(TOTAL {<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

Sum(TOTAL {<CLE,CLE= {"=Left(CLE,4) = '2017' and Match(Mid(CLE,5,2), '11') "}, COMPTE_TYPE_DEPOT -= {"AUTRES SOMMES DUES","CARTE","-","DEPOTS BANQUES DINARS"}>} COMPTE_SOLDE_COMPTABLE_TND)
THIS EXPRESSION WORKS I EXCLUTED cle

• Re: set analysis with function

I am not sure why you would do this.... as soon as your CLE, the second CLE won't work (the part in red will stop working)... is this really working for you?

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

• Re: set analysis with function

Wow, that is really strange, I would have not expected it to work... what do you get when you use this?

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

• Re: set analysis with function

THE TOTAL OF CLE

• Re: set analysis with function

Can you share an image please?

• Re: set analysis with function

HAHHA NOW, works   maybe I do not pay attention, thank youuuuuuuuuuu sunny

• 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 tried this solution but usually he result 0

• Re: set analysis with function

Looks like condition working. Because Left(CLE,4) is 2017 and then Mid(CLE, 5, 2)=11 that means these 2 conditions should satisfy. In your case, First one returns value and it shows as expected. Because the Second one showing for me first condition works but not second one which called Mid() - It returns 12 which won't satisfy ..

• Re: set analysis with function

i know this , and i execluted the cle ,
sum({<CLE,CLE= {"=Left(CLE,4) = '2017' and mid(CLE,5,2) = '11' "}, COMPTE_TYPE_DEPOT-={"AUTRES SOMMES DUES","CARTE","-","DEPOTS BANQUES DINARS"},CLE>}COMPTE_SOLDE_COMPTABLE_TND)