How to remove the 0 value from the Form calculation once it not filled out

  • Tom_Stalley
    Asked on June 20, 2024 at 4:05 PM

    Hello, is it at all possible to remove the default $0 from a calculated field? We have a form setup that multiplies quantity by unit price but even if nothing is entered on the form the value shows as 0.

    How to remove the 0 value from the Form calculation once it not filled out Image 1 Screenshot 20

  • Danilo JotForm Support
    Replied on June 20, 2024 at 4:52 PM

    Hi Tom,

    Thanks for reaching out to Jotform Support. They are showing zero values because the Form calculation widgets will always perform the calculation added. I would suggest removing all the formulas to all the Form calculation widgets. Then, you can use the Update/Calculate field conditional logic.

    First, you need to delete all the formulas to all the Form calculation widgets. Let me show you how:

    1. Hover your mouse over the Form Calculation, and click it.
    2. To open the formula editor, select the Form Calculation widget’s wand icon.
    3. Delete those formulas you added and select Save at the bottom.

    How to remove the 0 value from the Form calculation once it not filled out Image 1 Screenshot 50

    After you remove all the formulas, you need to create a conditional logic. Let me show you how:

    1. In the Form Builder, go to Settings at the top.
    2. Select Conditions on the left.
    3. Add a new Update/Calculate Field condition.

    How to remove the 0 value from the Form calculation once it not filled out Image 2 Screenshot 61

    • IF: INV
    • STATE: Is Filled
    • DO: Calculate a field’s value $ QTY *Price
    • SUMMARY:TOTAL1

    How to remove the 0 value from the Form calculation once it not filled out Image 3 Screenshot 72You need to repeat this conditional logic to the last Form calculation widgets. You can check my clone form here for further testing. You can clone it using this guide. Here's the result once any of them are not being filled out it will not show any value. I only create the first 3 conditions:

    How to remove the 0 value from the Form calculation once it not filled out Image 4 Screenshot 83

    Give it a try and let us know how it goes.

  • Tom_Stalley
    Replied on June 21, 2024 at 8:48 AM

    Thanks Danilo! That worked. A little more backend steps than I was hoping for but thank you!

 
Your Answer