Newbie Questions

Re: Count Occurrences of a Specific Entry in a Field

ToniHil — Thu, 13 Oct 2016 20:03:17 GMT

Were you able to solve this? I am having the same issue where it resets the count each time a different option is chosen. I added the + 1 but it continues to reset to 1 once the other value than the one I am counting is chosen. So when I select the one I am counting again, it starts it as though it were the first one. It is not collecting a history of how many times it is selected.

Re: Count Occurrences of a Specific Entry in a Field

JonathanShearman — Thu, 04 Feb 2016 00:11:31 GMT

YAY! Cracked it. I have to write the formula as count(function 1)+count(function2)+count(function3) I was trying to add all the functions with only one COUNT signifier (i.e. count(function1)+(function2)+(function3). So that was generating a NaN which means 'not a number'. So I figured it out. Anyway I will leave this here as someone else might find it useful.

Re: Count Occurrences of a Specific Entry in a Field

JonathanShearman — Wed, 03 Feb 2016 23:40:31 GMT

It's a form I am creating myself. I'm a consultant to an organisation who was hired as a technical writer but has ended up mainly doing SharePoint content development.

This form started out as a checklist in Excel, so I have taken that and converted it to InfoPath. They like InfoPath a lot, now they've seen it, but I'm pretty new to it myself (i.e. a month ago, didn't know anything beyond the name.)

I created the form as a set of repeating tables (i.e. Preparation Phase, Handover Phase, etc). Then I output the blank form and add rows to each section, and copy in the entries from the Excel sheet. Then I save that version as the actual 'user template' which the consultants are required to complete. This means I can update the controls on their forms by updating the content type, without changing the content.

Each row/task has a Status, which is a drop-down: Not Started, In Progress, Complete. When the consultant starts a new project, every row on the form will be Not Started. They work through the task list and gradually check off every row as In Progress and then Complete.

That is why we want to report on the overall status at a glance - so at the top of the Form, in the header, the GPMO can see the percentages.

Re: Count Occurrences of a Specific Entry in a Field

Hilary Stoupa — Wed, 03 Feb 2016 23:12:30 GMT

Hi - so, is this data you are counting from a secondary data connection in the form - like maybe a data connection to a SharePoint list? Are you 100% sure the value in the form is "In Progress"? Drag the field with the status onto your form and preview to make sure that is the actual value (same case, too, "In Progress" is not the same as "in progress" for example). Sometimes data from SharePoint lists in choice columns has some additional info in with it .... or, in the case of dates or times, may not be in the format we expect. :)

Re: Count Occurrences of a Specific Entry in a Field

JonathanShearman — Wed, 03 Feb 2016 22:55:04 GMT

I am trying to do a count of a task list with three status flags - Not Started, In Progress, Complete.

I have created a field which is supposed to display the count of each item using the following formula

count(CPS_Status[. = "In Progress"]).

That field is supposed to display the 'count' of number of fields in the CPS group with the status = In Progress.

But it doesn't work. Any tips appreciated.

Re: Count Occurrences of a Specific Entry in a Field

sakram — Mon, 18 May 2015 07:21:43 GMT

Hi, Bro. how can i use this formula if i have multiple drop down list. your urgent reply will be highly appreciated.

Re: Count Occurrences of a Specific Entry in a Field

swathip — Thu, 21 Aug 2008 05:27:01 GMT

Hi, You can use the following expression to count the number of times “red” appeared in TEAM field. count(TEAM[. = "red"]) Use the same expression for green and blue by replacing the red with appropriate colour. Hope this helps you.

Count Occurrences of a Specific Entry in a Field

dkenne — Wed, 20 Aug 2008 17:17:17 GMT

I know I can use the "count" function to yield the number of occurrences in a field, but is there a way to count (or tally) the number of specific entries in a particular field. For example, if I have a field called "TEAM" and it contains either "red," "green," or "blue" for each entry, can I have InfoPath count the number of times "red" appears, number of times "green" appears, etc.?

Any help is appreciated.

Thanks!