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 2: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.

    Jotform Thread 1069042 Screenshot
    Page URL: https://form.jotform.co/70469099638876
  • Chriistian Jotform Support
    Replied on February 17, 2017 at 4: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.

    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 Screenshot 20

    Related Guide: How to Perform Form Calculation in the Matrix Field?

    Please check and let us know if you need further assistance.
    Regards

  • juan7707
    Replied on February 17, 2017 at 9: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
    Replied on February 17, 2017 at 12:07 PM

    Hello Juan,

    So you would like that if it is selected like this:

    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 Screenshot 20

    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
    Replied on February 17, 2017 at 12:19 PM

    Exactly that's what I need 

  • Nik_C
    Replied on February 17, 2017 at 4: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.

    Thank you for your patience.

  • juan7707
    Replied on February 17, 2017 at 4: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
    Replied 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!