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

Avatar

Avatar
Validate 1
Level 1
chrisb29762052
Level 1

Likes

0 likes

Total Posts

25 posts

Correct reply

2 solutions
Top badges earned
Validate 1
Affirm 1
View profile

Avatar
Validate 1
Level 1
chrisb29762052
Level 1

Likes

0 likes

Total Posts

25 posts

Correct reply

2 solutions
Top badges earned
Validate 1
Affirm 1
View profile
chrisb29762052
Level 1

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
Springboard
MVP
Magus069
MVP

Likes

143 likes

Total Posts

1,078 posts

Correct reply

155 solutions
Top badges earned
Springboard
Validate 1
Ignite 3
Ignite 1
Establish
View profile

Avatar
Springboard
MVP
Magus069
MVP

Likes

143 likes

Total Posts

1,078 posts

Correct reply

155 solutions
Top badges earned
Springboard
Validate 1
Ignite 3
Ignite 1
Establish
View profile
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
Validate 1
Level 1
chrisb29762052
Level 1

Likes

0 likes

Total Posts

25 posts

Correct reply

2 solutions
Top badges earned
Validate 1
Affirm 1
View profile

Avatar
Validate 1
Level 1
chrisb29762052
Level 1

Likes

0 likes

Total Posts

25 posts

Correct reply

2 solutions
Top badges earned
Validate 1
Affirm 1
View profile
chrisb29762052
Level 1

03-08-2015

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

Take care.