# 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.

• juan7707
Asked 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.

• Chriistian
Answered on February 17, 2017 at 04:24 AM

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.
Regards

• juan7707
Answered on February 17, 2017 at 09:15 AM

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?

• Nik_C
Answered on February 17, 2017 at 12:07 PM

Hello Juan,

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.

Thank you!

• juan7707
Answered on February 17, 2017 at 12:19 PM

Exactly that's what I need

• Nik_C
Answered on February 17, 2017 at 04:36 PM

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.

• juan7707
Answered on February 17, 2017 at 04:43 PM

I found an alternative solution, it's fixed

but if you find a easiest way to work it out that a wil be great

• Nik_C
Answered on February 18, 2017 at 12:07 PM

Hello,

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.

Thank you!