3 Replies Latest reply on Aug 8, 2013 11:49 AM by Kerith Gaines

    count x value but exclude similar x value

    Kerith Gaines

      Hey Everyone!

       

      I'm scratching my head over setting up the count logic for this. I need to count the number of times "Blue" shows up in a column, and I need to exclude "Dark-Blue" - I tried the following:

       

      if contains ([Color], "Blue") then "1"

      elseif contains ([Color], "Dark-Blue") then "0"

      end

       

      But because Dark-Blue still has "Blue" in it, the Dark-Blue values are still being counted by the first if statement.

       

      How do I exclude Dark-Blue from the count?

       

      Thank you so much for your help!