1 Reply Latest reply on Mar 28, 2011 11:19 AM by philmodjunk

    Calculating Case Function Based on Results from Drop-Down Menu

    TeganHall

      Title

      Calculating Case Function Based on Results from Drop-Down Menu

      Post

      I'm trying to create a case function based on the result of a drop down menu.  I have a bunch of different studies that are in a drop down menu, and I would like a "date" to be associated with each study drop-down choice.  The case statement, which does not work, is below and attached as a screenshot.

      Case(Study 1 = Avenidas, "2009", Study 1=Mindset Manipulation, "2010", Study 1 = Flanker, "2006", Study 1 = Meditation Study, "2008", Study 1 = Nanna FYP, "2008", Study 1 = Sarah's Thesis, "2000", Study 1 = NN Exercise Pics, "2010", Study 1 = Walking Messages, "2011", Study 1 = Casey, "2000", Study 1 = Beeper Pilot, "2000", Study 1 = Michael CADMA, "2000", Study 1 = Nanna Pedometer, "2010", Study 1 = Healthcare, "2002", Study 1 = Face Morph, "2006")

      Capture.JPG