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

  • 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.

  • Kiran Support Team Lead
    Replied on April 25, 2019 at 3: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 Screenshot 10

    Hope this information helps!