4 Replies Latest reply: Mar 17, 2013 4:56 PM by Gareth Simms RSS

    GetFieldSelection - Multiple Selection Values in Count(If)

      Good Evening

       

      I am trying to create a chart that shows the values based on a Year Selection from my Master Calendar.  I am using the formula below

       

      =COUNT(IF(YEAR([CONTRACT END DATE])=GetFieldSelections(Year),1))

       

      This works fine if I only select one value (for example - Year = 2012), however, if I select a number of values, then obviously, it doesn't work.

       

      Is there a formula/adjustment that I can make so that if I select multiple values, I get the correct count?

       

      Thanks in advance.