1 Reply Latest reply on Jul 12, 2012 10:54 AM by comment

    Calculation Count 2 Fields Combined


      What does a calculation look like that counts the number of records with a Date Created 2012 but omits or is constrained by a field called Selected as a Previewer?


      Is this a Calculation or a Summary?

      The result should be a Number.


      I keep getting error messages re: field doesn't exist, wrong function, or needs an operator.


      I am a novice, but I'm good at following directions.


      The attachment shows my last attempt.


      Please help.



        • 1. Re: Calculation Count 2 Fields Combined

          bookman wrote:


          Is this a Calculation or a Summary?


          To summarize the found set, use a summary field.


          Note that Filemaker does not have a CountIf() function or summary field. You need to either define a calculation field to summarize, or reduce the counted set: by finding - in case of a found set - or by further filtering the relationship in case of a related set.


          Message was edited by: Michael Horak