I got awesome help creating the calculated fields used in Sheet 1 of the attached workbook. But I'm confused why the grand totals on Sheet 1 don't match the "Number of Participants" calculated on Sheet 3. Shouldn't they be the same?

I'm sure I would like Tableau Prep, however my management isn't willing to sink any more money into my Tableau foray as of yet, and I have a LOT of data to clean. I'd rather figure out how to do it the slow hard way, so that I can do it after the free trial runs out!

Unfortunately, while I do have a Tableau Desktop License, my license is Personal instead of Professional and so does not include Tableau Prep. ☹ My bosses want to make sure this Tableau thing is “worthwhile” before they throw more money at it.