My Summary Counts are Not Working
I'm trying to report on a guest list that I have created for an event. I have a field called RSVP Status that can be "No", "Yes", or "Yes + 1". I have created a calculated field called "RSVP Count" that correctly gives me a value of 0, 1, or 2 depending on the answer.
When I create my report sorted on RSVP Status the "Yes + 1" folks are only totaling 1 each when they should equal 2.
Is there a way to fix this or at least multiply that resuting field in the report to reflect the right number?