-
mmolakaAsked on May 6, 2025 at 9:09 AM
https://form.jotform.com/251205626594155
Not sure why the .00 is behind some of the figures, and some are not. Using the same fx formula inside the cell for "Comma Seperator"
Page URL: https://form.jotform.com/251205626594155 -
John JotForm SupportReplied on May 6, 2025 at 10:17 AM
Hi Michael,
Thanks for reaching out to Jotform Support. This behavior usually happens because of how the numbers are formatted in the form fields or calculation widgets. Some numbers might be stored or calculated as whole numbers without decimal places, while others are treated as decimal numbers, which display the .00.
If you want all your Form Calculation widgets to show consistent decimal places, you can enable Show empty decimal places option on each widget. It's easy to do. Let me show you how:
- Open you form in Form Builder, and click on the one of the Form Calculation widgets to select it.
- Click on the Wand icon to open its properties.
- In the right side menu, under the Calculation pad, click on Options.
- Put a check on Show empty decimal places option, and make sure the Decimal Places in Numerical Results dropdown is set to 2.
- Click on Go Back, then click on Save in the other page.
- Repeat the same steps to all Form Calculation widgets you have.
And that's it. Check out the screencast below for my results:
Give it a try and let us know how it goes.
Your Answer
Something Went Wrong
An error occurred while generating the AI response. Please try again!