4 Replies Latest reply: Feb 2, 2012 1:39 AM by jonahall RSS

    Multiple If in Expression

      I have the following Example data





      I need to find Number of Users who never used Card but used only Key.


      I set Dimension as Country


      For Expression I have used the following.


      Count (DISTINCT(If  (CardUsageCount=0, (If (KeyUsageCount>0, UserID)) )))



      I am supposed to get results as follows



      Country                  No Of Key Users wo never used card

      GERMANY                    1

      North. AMERICA             0

      BULGARIA                    0




      Bulgeria should not be counted because  the user has used card in August.In my result it is counted.


      Where am I making mistake?