Skip to main content
J
johnsbox
Known Participant
September 1, 2023
Question

Unwanted Zero(e)s are appearing in Field Text Boxes that I have Used the Calculate/Sum of + feature

  • September 1, 2023
  • 1 reply
  • 1545 views

Hello,

I am preparing a form for our shipping department and I have it set up to calculate taxes, palletizing, etc and give a total.  At first, it was giving me numbers with a bunch of decimal places like $37.555555557778 so I set the format to number and 2 decimals.  It also makes an unwanted zero appear in that space even though no data has been entered yet.  How can I fix this?  I want my calculations to remain the same and for the numbers to only display 2 decimal places but I don't want the zero there because we sometimes have to fill out the form manually.  I have very little experience with java script, I read up on some things but they do not make any sense to me.  If there is a flat out formula you know that I can just copy and paste to the custom format box that achieves this, please just let me know.  I greatly appreciate any help and thank you for your time.

This topic has been closed for replies.

1 reply

try67
Community Expert
try67Community Expert
Community Expert
September 1, 2023

You should know that the Format setting does not change the field's actual value, just the way it is displayed.

So if you add up two fields whose values are 2.555555557778 and 3.555555557778 (but they show 2.56 and 3.56), the result will be 6.111111115556, which would show up as 6.10. So if this is critical for you then you need to actually round them, using a script. This will also allow you to easily replace zero value with nothing.

Here's an example:

 

var v1 = Number(this.getField("Field1").valueAsString);
var v2 = Number(this.getField("Field2").valueAsString);
var total = v1+v2;
if (total==0) event.value = "";
else event.value = total.toFixed(2);
    J
    johnsboxAuthor
    Known Participant
    September 1, 2023

    I am completely lost ... do I change it to custom format and then enter the entire script you wrote?  Do I stop using the calculate function?  Does "Field One" need to be changed to the first field in the calculation using the name I designated? Same for "Field Two" ?

    try67
    Community Expert
    try67Community Expert
    Community Expert
    September 1, 2023

    You should change the custom Format of the fields to None and make sure they have the correct value using a calculation script, like the one I provided.

    Yes, replace "Field1" and "Field2" with the actual field names in your file that you want to add up.

      Terms & ConditionsAccessibility statement
      Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices