How to count dropdown options within a Form

[JohanSmith-07]

Hi, I have a "master form" that consolidates about 35 answers given by users through different screens, I need to count the number of filled questions in my "master form" so that I can calculate a completion rate. 

I tried creating a variable called Count_Fields_Filled and use it in the OnChange property of every field: 

the datacardvalue589 is a dropdown list within my form.

If(
    DataCardValue589.Selected.Value = Blank(),
    Count_Fields_Filled + 1,
    Count_Fields_Filled
)

Then I used the Count_Fields_Filled in a label, just show the total count but it shows 0 so it is not working. 

How could I count if the field has a value selected by the user? I also tried with IsEmpty and IsBlank but still not working,

If(
    IsEmpty(DataCardValue589.Selected.Value),
    Count_Fields_Filled + 1,
    Count_Fields_Filled
)

[Drrickryp]

@JohanSmith-07

Set(Count_Fields_Filled, Count_Fields_Filled+1)

[Tony_Bowes_BP]

It feels like this code would fire in EACH OnChange, so modifying the same variable 15 times would give you a count of 15 when in fact it's only one answer. 

A potentially better way to do it would be to simply display the results of a formula that adds up all non-blank answers. 

Formula would be something like:

(If(IsBlank(TextInput1.Text),0,1)
 + If(IsBlank(TextInput2.Text),0,1)
 + If(IsBlank(TextInput3.Text),0,1)
 )

[JohanSmith-07]

Thanks @Tony_Bowes_BP for some reason, when I delete a response from the form, the result is still counting it, it's like the result keeps on the cache memory or something, the following image should count 1 but as it had a response in 1.1 and then I delete it, it kept the counting. Any alternative to prevent this to happen?

[Tony_Bowes_BP]

For combo boxes, try checking against the value of the selected item: Eg: IsBlank(ComboBox1.Selected.Value1) 

[JohanSmith-07]

@Tony_Bowes_BP I did it but I'm having the same result

[Tony_Bowes_BP]

Here's an example of only 1 tex box filled: 

Then selecting one of the combobox items:

Then deleting the selection:

Code for the text label on the left is:

Concatenate((If(IsBlank(TextInput1.Text),0,1)
 + If(IsBlank(TextInput2.Text),0,1)
 + If(IsBlank(ComboBox1.Selected.Value1),0,1))
 , " out of 3") 

Depending on your combobox it might not be Value1 but the column name of the droplist options. 

Another way to debug would be to link up a TextLabel to the same value that you are trying to compare so you can visually see what the value is.