There's got to be a way...
Still new to FM 11Pro.
What I'm trying to do is get a report of a table that contains a dozen or so Y/N fields. The List View is fine. I've got headers and then all my rows of data. At the end, I have a summary field with the number of rows. What I want to do is sum all the Y fields for each column. I don't think I want a Summary View (all the Y's, followed by all the N's). I simply want summation fields for each column. If I had a field that could hold the sums, I think SQL would look something like "Select Count from Table where Field = "Y").
Is there a way to do this without having a dozen Table Occurrences? Is there some calculation (I can't seem to concoct one)? This has to be something that a lot of people do. I just can't seem to find the best way to do it.