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.