Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
It give the same result