Form Calculation is calculating incorrectly

  • skilltechstores
    Asked on September 16, 2024 at 9:51 PM

    This form https://form.jotform.com/240737610146856 - working fine except for the last to selection options under section "Items for Xcover6 Pro Only". If you enter 20 or 40 into these number properties boxes the calculation is multiplying by .2 or .4 instead of 20 or 40. For any other value the calculation works correctly. For every other number property entry the calculation works correctly (even if it is 20 or 40). Very strange, it appears only on these two values. I have reentered the formula for the calculated field several times without success. What am I missing here?

  • Jessica JotForm Support
    Replied on September 17, 2024 at 2:28 AM

    Hi skilltechstores,

    Thanks for reaching out to Jotform Support. We’ll need a bit of time to look into this. We'll get back to you as soon as we can.

    We appreciate your patience and understanding in this.

  • Jessica JotForm Support
    Replied on September 17, 2024 at 2:44 AM

    Hi skilltechstores,

    After more checking, this issue occurs due to Masked Input's Number Precision is set to 2. Therefore, since the calculation of 20, 40 quantity received a round number without comma ($41.00), Masked Input still convert the number precision to 2.

    Form Calculation is calculating incorrectly Image 1 Screenshot 60

    You might want to consider removing Masked Input, and add $ string at the beginning of your Form Calculation. Let me walk you through the steps:

    1. In Form Builder, click on Calculate Value.
    2. Click on wand icon beside the blue border. Form Calculation is calculating incorrectly Image 2 Screenshot 71
    3. Add $ at the beginning of calculation. Make sure it's colored gray. Form Calculation is calculating incorrectly Image 3 Screenshot 82
    4. Scroll down and click on Save.

    When it's a round number, your Form Calculation will not show the decimal, such as below:

    Form Calculation is calculating incorrectly Image 4 Screenshot 93

    But when it's decimal number, your Form Calculation will show it as per usual:

    Form Calculation is calculating incorrectly Image 5 Screenshot 104

    Let us know if you need more help.

  • skilltechstores
    Replied on September 17, 2024 at 3:39 AM

    Ok that's a much neater solution by putting the mask on the calculated field.

    I also found that by using the options on the Calculation Widget the decimals can be shown and by making it read only I've eliminated the other two fields (which was not very elegant) and just make Calculation Widget display the value for approval and drive the visibility of the submit button.

    Form Calculation is calculating incorrectly Image 1 Screenshot 20

  • Silvano JotForm Support
    Replied on September 17, 2024 at 3:57 AM

    Hi skilltechstores,

    Just to confirm, this is now resolved, and you're fine with the resolution provided by my colleague and the minor changes you made. Right?

    Reach out again if there’s anything else we can help you with.

  • skilltechstores
    Replied on September 17, 2024 at 4:04 AM

    Yes all resolved.