Why avgNoZero() math function is not working on our form?

  • Profile Image
    Brian_Sweeney
    Asked on April 24, 2019 at 11:08 PM

    Hi guys,

    I've just created a new account because of a whole lot of forms we need to create.  I've created an input table and then I'm using the Math Function to do some calculations.

    When I just do a simple FIELD x 4 + FIELD x 9 + FIELD x 4 math function it works fine.

    However when I try to use the avgNoZero() math function it's not working.

  • Profile Image
    Kiran
    Answered on April 25, 2019 at 03:11 AM

    I have checked your JotForm and see that the avgNoZero function is set correctly in the calculation. However, the commas that are separating the values are set as the text field which is causing the issue. Please click on the commas to change them to calculable text (to black) so that the formula should be working fine. 

    155617622125042019_120451.png

    Hope this information helps!