2 Replies Latest reply on Oct 13, 2016 1:06 PM by TSPigeon

    Count Evaluation


      Why does this evaluate to 1 vs. 3


      What do i need to do to get it to evaluate it to 3?


      My understanding is that is should count the lines or the returns....?

        • 1. Re: Count Evaluation

          The COUNT function returns the number of valid fields, which is why it's returning the number 1.  It's counting the field, not the values.


          You want to use the VALUECOUNT function, which will return the number three as you desire.

          See the attached image:Screen Shot 2016-10-13 at 3.58.15 PM.png

          • 2. Re: Count Evaluation



            Thank you for your post.


            If it's returning "1", "INAdditionalServices" may not be a repeating field. Count requires One Repeating Field or Several Non-Repeating Fields. You might see the Count Function listed in: https://fmhelp.filemaker.com/docs/15/en/fmp15_functions_ref.pdf 


            I am also going to move this thread from the FileMaker Community Feedback Space, which is specifically for input on the Community itself, to the Discussions Space where you should receive more views and potentially more advice on this topic!



            FileMaker, Inc.