-
jgrassettiAsked on December 9, 2020 at 12:30 PM
I have a form (WFIRS-S) that uses tables with column values corresponding to 0,1,2,3,n/a. Is there a way for me to perform calculations without the n/a value causing problems? For example can I create a calculation field that sums the values if they are not equal to n/a or counts the values if they are not equal to n/a?
thanks
-
KrisLei Jotform SupportReplied on December 9, 2020 at 3:52 PM
Hello,
I have checked your form. I can see that you are referring to the Input Table fields with assigned values. Unfortunately, it will not calculate the numeric values correctly with the "n/a" value.
You may try to assign a zero value if you would like not to include it in the calculations. May I ask if how you would like the calculate the 'N/A' value to assist you further?
Thank you. Looking forward to your response.