set analysis

[#1]

sum(Montant)-(sum({<Reg_Etat={'Confirmé'},Reg_Mode={'Chèque','Effets'},Reg_Type={'Chèque Impayé'}>}Montant))-sum({<Reg_Etat ={<>'Chèque Impayé'}>}Montant)

[Gysbert_Wassenaar]

42?

[#3]

That is the answer but what is the question?

[awhitfield]

Wise Man says: To get a sensible answer, you need ask a sensible question! Or at lease a question!

Andy

[#5]

Sorry, cause I need to use different to 'Chèque Impayé', but ther's some mistakes in this expression:

sum(Montant)-(sum({<Reg_Etat={'Confirmé'},Reg_Mode={'Chèque','Effets'},Reg_Type={'Chèque Impayé'}>}Montant))-sum({<Reg_Etat ={<>'Chèque Impayé'}>}Montant)

[Gysbert_Wassenaar]

Try: sum({<Reg_Etat -={'Chèque Impayé'}>}Montant)

[stigchel]

Try with

sum({<Reg_Etat =-{'Chèque Impayé'}>}Montant)

[buzzy996 · Accepted solution]

ya,

sum({<Reg_Etat = - {'Chèque Impayé'}>}Montant)