Maybe I haven't had enough coffee yet, but I don't seem to be able to figure this out today. It's probably the most basic calculation possible.

I have a field where I need 'yes' or 'no' answers and the totals. Since FM7 doesn't recognize 'yes' or 'no' and I don't want my users to have to deal with 1 and 0, I've been creating a calculation "if (field) = "yes", 1,0)" then totalling that field (summary, total of (field)).

How do I do this without the middle calculation field? Just total the yes and no responses directly?

TIA

You could use a sub-summary report where the break field is your field, with a Count of RecordID to show the count for each answer.

So this was actually a valid question and not just me experiencing a brain freeze???

The problem is actually a little more complex. Workshop participants must indicate EACH night's lodging required. For example they might say yes to lodging on monday and tuesday but no to lodging on wednesday. I need to show totals per participant as well as the summary total of all nights lodging is needed.

Thanks for your help.