Afternoon,

I’m struggling to produce any reports or pivot tables with the numbers from a multiple choice selection.

i have a form where people select how many adults were on a trip, and choose zero to 12. I want to then add up total adults that day, but I can only seem to get tables or reports to tell me how many trips had 4 adults, how many had 5 etc... now I guess I can run a formulae that multiples total trips with 4 people to generate the total adults, but if I extend table to say up to 100 .. this becomes immense.

im guessing the system does not see the numbers as an actual integer.

any thoughts on this? I would prefer not to make entry free form integer as it has a specific use case that requires simplicity (used on a moving boat).

thanks

andrew