Count to equate to the instance total of single value from the drop down table???

chrisb29762052

31-07-2015

I am just a beginner. I know how to code in order to get a automated count of the rows but I am trying to go one step further.

I would like to be able to get a number that equate to  the number of time that a value was picked from a drop down list.

I have attached a couple illustrations to explain what I  am trying to achieve :

Pic 10.PNG

At the end I would like to end up with something like this.

pic11.PNG

Any assistance would be much appreciated.

Accepted Solutions (1)

Accepted Solutions (1)

Magus069

MVP

01-08-2015

Hi there,

To do something like this you need to use the calculate event of the count field.

What you want to do is to count how many times the name in the dropdown list is selected up to this row.

If you use this for loop using JavaScript and change it with the names for your form it should look something like this :

And in FormCalc :

Hope this help!