How do you tell whether a dash adds to the total for B instead of A?
This would be easier to tabulate if each field shown was the same field in a set of related records. Please note that a set of related records can be displayed horizontally as well as the more typical vertical orientation inside a single portal.
The dashes add equally to both the A's and the B's. As in the example you will see that when you total the number of A's plus the dashes (each dash equals 1/2) you get 10.5. When you add the B's plus the dashes, you get 7.5.
Will it work for you to use one related record for each value of A, B or - ?
As long as I am able to incorporate it into my existing data base, I would think that would be okay.
Well I can't tell if you are able to "incorporate it into your existing database" or not...
If you have FileMaker 12 or newer, the executeSQL() function can count all records where the field is A, all where the field is "-" and all the B's related to the current record on your layout.
Without executeSQL(), you can either set up 3 different relationships to different table occurrences of this new related table of Values or a single relationship with two one row filtered portals with a summary field in the portal row.
Or you can set up three calculation fields in the related table:
Field = "A"
Field = "B"
(Field = "-" ) / 2
Then your parent table can calculate your counts:
Sum ( RelatedTable::cAflag ) + Sum ( RelatedTable::cHyphenFlag )
would be your count for A.
As always, Phil - Perfect! Thank you!