6 Replies Latest reply on Aug 6, 2017 9:43 AM by blackcatenterprise

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

    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.