2 Replies Latest reply: Jun 17, 2017 8:14 PM by Imran Khan RSS

    Count

    Andrew Slaiby

      Trying to Count the number of Yes's in a Field [Dynamic 2017 (Y/N)]... keep getting error message.

       

      Count({$<[Dynamic 2017 (Y/N)]={'Y'}>})

        • Re: Count
          Onno van Knotsenburg

          And what is the error message that you are getting?

           

          What I notice is that your expression is missing the actual field to count. It seems to only contain the Set Analysis section.

          Try this:

          Count({$<[Dynamic 2017 (Y/N)]={'Y'}>} [Dynamic 2017 (Y/N)])

          • Re: Count
            Imran Khan

            try this one -

            =Count({$<[Dynamic 2017 (Y/N)]={'Y'}>} Distinct [Dynamic 2017 (Y/N)])


            this will give you unique count. First try it in the text object for testing then place it anywhere