AnsweredAssumed Answered

There's got to be a way...

Question asked by JimBessette on Nov 25, 2013
Latest reply on Nov 26, 2013 by JimBessette


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.