You can use a summary field with count on the found set of meeting invites grouped by status.
Hi and thanks for replying.
I think I understand your suggestion - but could you help me with an example of the formula line?
I have a field with checkbox: Customer accepted meeting "yes" or "no". I'd like to now my succesrate on the "Yes to meeting" compaired to the entire number of records in DB.
What I mean is - which formula to use - and how would it look?
Thanks in advance...
Thank you for your post.
I don't know what version of FileMaker Pro you are using, but the following should work for all versions of FileMaker Pro.
Create a calculation field, "CALC" with the following formula:
If ( Customer accepted meeting = "Yes"; 1 ; 0 )
Create a Summary field, "PERCENT" with the summary option Average of CALC.
The result in PERCENT will give you a percentage of those Customers that replied "Yes".
Let me know if you need clarification.