General

Re: Count Instances of a Number

Hilary Stoupa — Fri, 01 Sep 2017 16:08:13 GMT

Happy to help. Have a great weekend!

Re: Count Instances of a Number

powersma — Fri, 01 Sep 2017 15:59:36 GMT

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!

Re: Count Instances of a Number

Hilary Stoupa — Fri, 01 Sep 2017 15:38:57 GMT

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. :)

Re: Count Instances of a Number

powersma — Fri, 01 Sep 2017 15:23:45 GMT

Sure! Here you go!

Re: Count Instances of a Number

Hilary Stoupa — Fri, 01 Sep 2017 15:19:20 GMT

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.

Count Instances of a Number

powersma — Fri, 01 Sep 2017 13:58:15 GMT

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.