Calculations with a mix of numbers and strings

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

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.