Calculations with a mix of numbers and strings

  • Profile Image
    Asked on December 09, 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?


  • Profile Image
    Answered on December 09, 2020 at 03:52 PM


    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.