AnsweredAssumed Answered

Calculated Field Problems

Question asked by bokenrosie on Jul 9, 2013
Latest reply on Jul 9, 2013 by bokenrosie

Title

Calculated Field Problems

Post

     I'm trying to get a count to tell me if guests are coming to an event.  
     I have a field called RSVP Status and the choices are radio buttons for No, Yes, or Yes+1.
     I have a calculated field that I've loaded with the following calculation that does not give me what I want.
     I'm looking for it to put either 0, 1, or 2 in the field and I only get a 1 for no so I'm completely lost.  
      
     If 
     (Thursday Dinner RSVP="yes"; Thursday Dinner RSVP Count=1;If(Thursday Dinner RSVP="yes+1"; Thursday Dinner RSVP Count=2;If (Thursday Dinner RSVP="no"; Thursday Dinner RSVP Count=0)
      ))
      
     Any help would be greatly appreciated.

Outcomes