2 Replies Latest reply: May 14, 2013 5:24 AM by victor59 RSS

    Multi conditional expression

      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