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

    Multiple If in Expression

      I have the following Example data

      ExcelData.JPG

       

       

       

      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?

       

       

      Thanks