4 Replies Latest reply on Jul 9, 2013 4:35 PM by bokenrosie

    Calculated Field Problems

    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.