Calculation Widget: Count Function Not Returning Numeric Result

I've tried for hours, even working with your AI and my AI. after dozens of tries, I just cant get your count function to work on my calculation widget. i want to count the questions answered with a number. the questions responses have values. with the exception of "please respond" which leaves blanks. the formula just returns a string, not the actual calc. {COUNT} ( {field1}, {field2}, {field3}) Ive made sure the ( and , are black so treated like a number not a string. I've made sure all the questions are scorable. can you tell me what i need to fix?

Hi Greg,

Thanks for reaching out to Jotform Support. I saw that your Form Calculation widget isn't working properly. I've cloned your form and tested it to see if I can replicate the issue, and the same thing happened to me. When I investigated your form, I saw that you're using the Count function on your Dropdown fields, and there's no plus sign between your fields in the Form Calculation widget.

Take note that the Count function won't work in your Dropdown field because the Dropdown field is automatically counted as one only, but the Count function will work on your Multiple Choice widget because it has multiple options. Since your Dropdown fields have calculation values on their options, you can remove the Count function and add a plus sign between your fields. Let me show you how to do it:

1. In Form Builder, click on the Wand icon of your Form Calculation widget.
2. Then, copy the formula on the screenshot below, and click on Save on the right side of the page.

I've applied the said changes on the clone version of your form to demonstrate it. Check out the screencast below:

As you can see, it is now working properly. You can clone my demo form as your reference.

Let us know if there’s anything else we can help you with.

Actually, the "Questions Answered" field is a little different. I was trying to count any time the selection moved off of "Please Select" (with a value of blank) and the question was answered (with a value of 0 or greater) So that's what got me to looking at the {Count}() function. count 1 for any question with a number, dont count if blank ("Please Select")

I've tried every syntax of {count}() i could think of.

Actually, the calculated field above this one named "Total Points" has the same formula that you used in the demo form, and, agreed, its adding up the points.

I just cant seem to get a {count}() of questions, even when the value is 0

Do you have any other ideas, it's so close!

Hi Greg,

To make the form count if the field filled in, you will need a helper for each field. For this demo, I will be using a Short Text field as a helper. Let me walk you through it:

1. In Form Builder, click on Add Element and drag-drop a Short Text fields.
2. Next, click on the Type a Question text and change it to the question you want to use.
3. Click the Gear icon then go to Advanced tab and enable the Hide Field option.

Now, let's set up the conditions:

1. In Form Builder, in the orange navigation bar at the top of the page, click on Settings.

2. Next, click on Conditions on the left of the page.

3. Now, click on Update/Calculate Field to create your condition (if you already have a condition, first click on Add Condition and then click on Update/Calculate Field).

4. Set the conditions like you see below and click on Save:

Now, you can update the Form Calculation widget to get the total questions answered like this:

Check out the screencast below to see what happens when the condition is met or not met:

Reach out again if there’s anything else we can help you with.

Ronald, its official, I completed your reocmmendations to all the questions and your workaround to the {count]() function works GREAT!

THANKS for your help, that was very creative!

Hi Greg,

I’ve gone ahead and moved your other question to a separate thread to keep things tidy, and someone from our Support Team will help you out with it here.

Let us know if you have any other questions.