Count Instances of a Number - InfoPath Dev Sign in | Join | Help in General InfoPath (Entire Site) InfoPath Dev InfoPath Dev is dedicated to bringing you the information and tools you need to be successful in your Microsoft Office InfoPath development projects. Home Blogs Forums Photos Downloads InfoPath Dev » InfoPath » General » Count Instances of a Number Count Instances of a Number Last post 09-01-2017 09:08 AM by Hilary Stoupa. 5 replies. Page 1 of 1 (6 items) Sort Posts: Oldest to newest Newest to oldest Previous Next 09-01-2017 06:58 AM powersma Joined on 07-01-2015 Posts 8 Count Instances of a Number Reply Contact I have eight dropdown fields with the option of 1-4 in each one. I need to count how many instances (of that 8) that I have 1's, 2's, 3's and 4's. I've tried a bunch of different formulas but I can't figure it out, so any help would be great. 09-01-2017 08:19 AM In reply to Hilary Stoupa Joined on 06-20-2008 Posts 13,297 Re: Count Instances of a Number Mark as Not AnswerMark as Answer... Reply Contact Any chance you can attach a copy of your form in a reply? Under the Options tab you can attach a file. The approach may vary based on your form schema. Hilary Stoupa 09-01-2017 08:23 AM In reply to powersma Joined on 07-01-2015 Posts 8 Re: Count Instances of a Number 90 Day Eval.xsn Mark as Not AnswerMark as Answer... Reply Contact Sure! Here you go! 09-01-2017 08:38 AM In reply to Hilary Stoupa Joined on 06-20-2008 Posts 13,297 Re: Count Instances of a Number 90 Day Eval.xsn Mark as Not AnswerMark as Answer... Reply Contact Save the attached copy locally. Right click the saved file and select Design to open in design mode - from there you can preview and try it out. Since your data isn't repeating, we have to add the count of the filtered instances of each node together. :) Hilary Stoupa 09-01-2017 08:59 AM In reply to powersma Joined on 07-01-2015 Posts 8 Re: Count Instances of a Number Mark as Not AnswerMark as Answer... Reply Contact That is so great! One of my formulas at one point was *sort of* close, but I wouldn't have come up with this - thank you very much! 09-01-2017 09:08 AM In reply to Hilary Stoupa Joined on 06-20-2008 Posts 13,297 Re: Count Instances of a Number Mark as Not AnswerMark as Answer... Reply Contact Happy to help. Have a great weekend! Hilary Stoupa Page 1 of 1 (6 items) Copyright © 2003-2019 Qdabra Software. All rights reserved.View our Terms of Use.
I have eight dropdown fields with the option of 1-4 in each one. I need to count how many instances (of that 8) that I have 1's, 2's, 3's and 4's. I've tried a bunch of different formulas but I can't figure it out, so any help would be great.
Any chance you can attach a copy of your form in a reply? Under the Options tab you can attach a file. The approach may vary based on your form schema.
Sure! Here you go!
That is so great! One of my formulas at one point was *sort of* close, but I wouldn't have come up with this - thank you very much!