AnsweredAssumed Answered

how do I calculate number techs (for example) out of TITLE field.

Question asked by blackcatenterprise on Jul 29, 2017
Latest reply on Aug 6, 2017 by blackcatenterprise

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.

Outcomes