5 Replies Latest reply on Nov 26, 2013 7:19 AM by JimBessette

    There's got to be a way...

    JimBessette

      Title

      There's got to be a way...

      Post

           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.

           Thanks,

           Jim