Incorrect Calculations in the Form

  • rahulranjan45707
    Asked on July 7, 2025 at 3:36 AM

    "When State = Delhi, Total NTH comes in negative. All conditions and formulas seem okay, please check and fix."

  • rahulranjan45707
    Replied on July 7, 2025 at 3:38 AM

    -144883.50 total NTH is wrogly showing.

  • Sheena JotForm Support
    Replied on July 7, 2025 at 3:53 AM

    Hi Rahul,

    Thanks for reaching out to Jotform Support. I cloned your private form and tested it to see if I could replicate the issue, but everything was working properly. Check out the screencast below to see my results:

    Incorrect Calculations in the Form Image 1 Screenshot 20

    As you can see, the Total NTH is not showing any negative value when the State is equal to Delhi. Can you take a screenshot of what’s happening and send it to us? We’ve got a guide here that’ll show you how to do that.

    Once we hear back from you, we'll be able to move forward with a solution.

  • rahulranjan45707
    Replied on July 7, 2025 at 4:15 AM
    Total nth is showing right now please check again
    *With Best Regards*
    *RAHUL RANJAN*
    ...
  • rahulranjan45707
    Replied on July 7, 2025 at 4:15 AM
    Total nth is showing negative right now when we are selecting location as
    delhi please check again and fix it.
    *With Best Regards*
    *RAHUL RANJAN*
    ...
  • Mahmoud JotForm Support
    Replied on July 7, 2025 at 4:45 AM

    Hi Rahul,

    I cloned the form, and I couldn't replicate the same issue on my end, as you can see in my screencast below:

    Incorrect Calculations in the Form Image 1 Screenshot 50

    I checked the calculations for the Total NTH field and noticed that it’s configured twice, once within the widget itself and again through conditions. To avoid conflicts or confusion, I recommend using only one method. Additionally, you just need to remove the initial + in your calculation widget for it to work correctly.

    1. In Form Builder, click on the Wand icon of the Calculation widget.
    2. In the menu on the right side of the page, remove the First + from your calculations.
    3. Click on the Conditions icon of the Calculation widget.
    4. You can remove the calculations there and keep the widget calculations.

    Incorrect Calculations in the Form Image 2 Screenshot 61

    To help us investigate further, you can share a screenshot showing the inputs so we can identify where the issue might be. I noticed you have several conditions set up to calculate the Total NTH field at the end. One of your answers may be triggering a conflict, but we haven’t been able to replicate the issue on our end. Let me show you how to post a screenshot to our Help Center:

    1. On the Help Center page, scroll down to the Your Answer section and click on the Image icon.

    2. Drag and drop your image into the Upload box, or click on it and select your file.

    3. Then, click on the Add button in the bottom-right corner of the window.

    Incorrect Calculations in the Form Image 3 Screenshot 72

    4. To resize it, click on your screenshot and then click on one of the boxes in the corners, and drag it inward.

    5. Once you're finished, click on the Post Answer button at the bottom right of the Your Answer section.

    Incorrect Calculations in the Form Image 4 Screenshot 83 That's it. Once we hear back from you, we'll be able to help you with this.

  • rahulranjan45707
    Replied on July 7, 2025 at 4:52 AM

    Incorrect Calculations in the Form Image 1 Screenshot 20

  • rahulranjan45707
    Replied on July 7, 2025 at 4:54 AM

    state is delhi and monthly CTC is 50000 please check in preview form.


    TOTAl nth is showing again negative and not coming as per condition logic

  • rahulranjan45707
    Replied on July 7, 2025 at 5:09 AM

    please check and fix from your side.


  • Mahmoud JotForm Support
    Replied on July 7, 2025 at 5:44 AM

    Hi Rahul,

    When I checked the form, I noticed that the PF Employee field is calculated as 1800,00 instead of 1800. Because of this formatting, the negative sign will always appear based on your calculations, as shown below:Incorrect Calculations in the Form Image 1 Screenshot 40

    Upon further checking, I noticed that the decimals are set to display 2 decimal places in the numerical results. This should be set to 0 instead, as shown below:

    1. In Form Builder, click on the Conditions icon of the Calculation widget.
    2. Hover over the last condition and click on the Pencil icon.
    3. Click on the Small Gear icon to open the calculation Options
    4. Select 0 next to the Decimal Places in Numerical Results and click on Save.

    Incorrect Calculations in the Form Image 2 Screenshot 51

    Check out the result of my test below:

    Incorrect Calculations in the Form Image 3 Screenshot 62

    Reach out again if you need any other help.

  • rahulranjan45707
    Replied on July 7, 2025 at 5:57 AM

    thnx essue has been resolve.