This would be so simple as a SQL statement. How in blazes do I do this with fmp anyone? SO I have employee files, and they have titles. This titles can be edited so each is assigned an ID to identify it, since the title could be anything. Now I need to be able to calculate how many "X" titles are in all the records.
I would think get the sum of X field where Y is equal to BLAH but even if this is all where and how do I do this sort of SQL like calc in FMP? Been trying everything and looking everywhere...
TITLES are a table itself
I hope to make some charts of this calc later.