What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    "Round Up" for tax calculation.

    Asked by jssales on July 26, 2016 at 03:59 PM

    Hello, I need to calculate tax on a form and I'm having some issues. However, due to the nature of the system I cannot use the PO form or any other type of payment form.

    TotalOrder * .07275 = Output

    TotalOrder + Output = Cost

    If I change the Cost to 2 decimal places the form does not "round up" for tax calculations.

    Example:

    9 * .07275 = .65475

    9 + .65475 = 9.65475 (cost)

    If I tell the system to format using 2 decimal places I get 9.65 and I actually need it to read 9.66

    Can you think of any way to change this so it calculates properly? Thank you.

     

     

    Page URL:
    https://form.jotform.com/jssales/bigospopandwaterorderform

    tax tax calculation round up for
  • Profile Image
    JotForm Support

    Answered by BDAVID on July 26, 2016 at 05:16 PM

    It is actually calculating properly, the round up is done when the next decimal number is greater than 5, and in this case "9.65475" stays at 9.65 because the next decimal number is 4.

    If you want to, you could add "+ 0.01" to the calculation. Let us know if you need more help.

  • Profile Image

    Answered by jssales on July 26, 2016 at 05:49 PM

    Thank you, you're correct, this one works. I tested so many of them, I cannot remember which one it didn't work on. I'll give it a go and see if I run into another issue. Thank you for the quick reply!