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).