Multi conditional expression

[#1]

Hello,

I want to do this, but if I understood correctly, it's not allowed to use AND and OR in expression.

I work with QV 10.

Have you an other solution ?

In expression ==>

= if(

(

(Comptabilite.type = 'QCO' OR Comptabilite.type = 'TER' OR Comptabilite.type = 'RIS') AND isnull(Comptabilite.dateregcom)

)

OR

(

(Comptabilite.etat = 'S' or isnull(Comptabilite.etat)) AND not isnull(Comptabilite.dateregcom)

)

, sum(Comptabilite.primettc) - sum(Comptabilite.commission))

Thanks a lot,

Victor

[jonathan_dau]

Maybe you could try this one. Not sure though

=

     if(

Comptabilite.type = 'QCO' OR

Comptabilite.type = 'TER'  OR

Comptabilite.type = 'RIS' AND

isnull(Comptabilite.dateregcom),sum(Comptabilite.primettc) - sum(Comptabilite.commission),

     if(

Comptabilite.etat = 'S' OR

isnull(Comptabilite.etat) AND

not isnull(Comptabilite.dateregcom), sum(Comptabilite.primettc) - sum(Comptabilite.commission)))

Jonathan

[#3]

It give the same result