5 Replies Latest reply: Apr 23, 2017 7:32 AM by Vineeth Pujari RSS

    count if x = O or Y= O

    mouhanned ben braham

      hello

       

      i have a little problem i have three table

      table tiers ; cod_tiers , age , nom , prenom

      table presence ; cod_tiers , present ( yes , no , null )

      table vote ; cod tiers , vote ( yes , no , null )

       

      what i want is count cod_tiers if present = yes or vote = yes

      i tried this but it is incorrect =count({<VOTE={'O'},PRESENCE={'O'}>} COD_TIERS) this give me present = yes and (not or ) vote = yes

       

      thank you for your answer in advance