What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.
We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
I want to divide the result of each matrix if the column cumpio or no cumplio were selected, the NA it wasn´t to be counted.Asked by juan7707 on February 17, 2017 at 02:28 AM
how can I count the number of boxes that were selected as NA in my matrix
I want to divide the result of each matrix if the column cumpio or no cumplio were selected, the NA it wasn´t to be counted.
I checked your form (https://form.jotform.co/70469099638876 ). I noticed that the calculation value for the NA is not a numerical value that's why it is not counted.
Related Guide: How to Perform Form Calculation in the Matrix Field?
Please check and let us know if you need further assistance.
i tried with a numeric value, but I can´t
What I need is that in the calculation field of the column NA is not considered in the numerator, but in the denominator it is weighted, for instance, if they are 4 rows, but one of them is selected as NA, then instead of dividing it Between 4, which is between 3. what do I have to do?
So you would like that if it is selected like this:
To be calculated 100%. 3x100 divided by 3 because N/A is selected?
Let me check this further and I'll get back to you ASAP.
Exactly that's what I need
I just wanted to follow up, I tried to make this work, no luck so far.
But, I'll try more to make it work and I'll certainly get back to you.
Thank you for your patience.
I found an alternative solution, it's fixed
but if you find a easiest way to work it out that a wil be great
I'm sorry for this delay.
I tried to make this work, but all solutions I came to are very complicated and not elegant. I tried to make a logic that will hold the data when NA option is clicked and then use that value to deduct from number 4, which is used to divide. But then, later, there is a problem with values used in a calculation, so I'm not getting the round number. Anyhow, that solution would require a lot of new fields and new calculations for each matrix field.
If you came up with a solution that is workable for you, please try with it and feel free to share.
If I find some other solution with this setup I'll get back to you.