3 Replies Latest reply: Aug 3, 2018 4:36 AM by Whiteside Kleinbreuer RSS

    Count expression with an OR funktion?

    Whiteside Kleinbreuer

      Hello Everyone,

       

      This one really give me a headache.

       

      I am trying to count actually IDs that have either "Attribute 1" X or y  OR "Attribute 2" X or y.

       

      My current Syntax is this:

      count({<[Attribute 1]={'X','y'},[Attribute 2] ={'X','y'}>} distinct ([ IDs ]))

           

      and the Number that shown up is 743 (13+730).

      I gues this makes sense from the Syntax.

       

      But How am i suppose to rewrite it so i get 1280 (13 + 730 + 537) without mentioniong B in my syntax? I just want "Attribute 1" X or y  OR "Attribute 2" X or y.

       

      best regards

      whiteside