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

Avatar

Avatar

chrisb29762052

Avatar

chrisb29762052

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)

Avatar

Avatar

Magus069

MVP

Avatar

Magus069

MVP

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!

Answers (1)

Answers (1)

Avatar

Avatar

chrisb29762052

Avatar

chrisb29762052

chrisb29762052

03-08-2015

You were a great help again. It works exactly the way I was hoping for.

Take care.