Form Calculation: Turn negative result to zero

SPANISH QUESTION:

Qué función matemática puedo usar en un campo calculado en una forma de cálculo para que si el el resultado es negativo la función lo cambie a cero.

ENGLISH QUESTION:

What mathematical function can be used in a calculated field in a calculation form (Widget) so that if the result is negative the function change it to zero.

I will appreciate your help.

Thanks.

Hi,

We do not have this function available in the calculation wizard. Let me add this as a feature request as I find it useful. Hopefully our developer will be able to consider this in the future implementation.

As for now, what you can do is to take your form source code and apply custom script that turns negative result to zero. If you need assistance with this, let us know and we'd be happy to provide you a walkthrough.

Regards!

Thanks a lot for your quickly respond, I would like apply script that turn negative results to zero in some calculation fields in my forms. I will really appreciate your support.

Hi,

You can also use the Math function max() -- it has a parameter like this max(0, n).

Using max() the negative number can be round-up to zero(0).

Test this form http://form.jotform.me/form/41159141656454? , make the result negative by subtracting 2nd number as higher than 1st number like this

In my test form, the condition I setup is like this

Please tell us if this will work on what you need and we will also assist you apply this on your form.

Thanks.