* create calc field (type text) const_clients = "clients"
* create additional table ocurrence of this table
* connect both in a self relationship const_clients -> categories
* calc field = count( self_rel::ID ) will give your result
Thank you for your response.
Unfortunately, I am very new to FMP as I just switched over from Bento.
Could you please be a little more detailed as to how to implement your solution so a novice like myself could understand it.
Thank you very much, your help is greatly appreciated.
I created a small demo file to illustrate the technique. Please contact me privately (top of this page - right side - X Messages) with your email address and I will send a file back to you.
I would love to know what the exact fix for this situation. I have the same exact problem/question.
I'm assuming this is all taking place in one table.
We'll call this table Main. Define a calculation field, cClientsKey and enter "Clients" as its calculation.
In Manage | Database | Relationships, click Main to select it, then click the button with two green plus signs to create Main 2--a second table occurrenc of Main.
Create this relationship:
Main::cClientsKey = Main2::Category
Define this calculation field in main: Count ( Main2::Category )
And it will compute the count of all records in main with the value "clients" in the category field.
You've done it once again Phil, THANKS!!!
Your solution worked perfectly. I am now wondering if this calculation can work based on currenet year. In other words if I have a 1,000 records but only 50 of them are from thise year can the calculation only show results from the current year.
Thank You in advance