Rounding

5 replies
461 views
Translate

Dear community,

I am Marcel from Germany. I have been unsuccessfully trying to round a given number (e.g., 5.25) to two decimal places in a commercial manner (rounding up with 5, 6, 7, 8, 9 and rounding down with 1, 2, 3, 4). The result should be 5.30, but with JavaScript, I always get 5.20, which is incorrect. Unfortunately, I cannot find an option in Acrobat Pro DC to solve this common problem. Neither Google nor ChatGPT have provided a solution. Can anyone help me?

Thank you!
Marcel

Adobe Applications

try67

Community Expert

As the custom Calculation script of the field (NOT Format!), use this code:

if (event.value) event.value = Number(event.value).toFixed(2);

Translate

M

marcel_5366Author

Participant

Thanks for your answers =)))

At the moment I have this one:

(function() {

var hin = parseFloat(this.getField("Km HinfahrtFahrt mit dem privaten Pkw")
.valueAsString.replace(",", ".")) || 0;
var rueck = parseFloat(this.getField("Km RückfahrtFahrt mit dem privaten Pkw")
.valueAsString.replace(",", ".")) || 0;

var kosten = (hin + rueck) * 0.35;

var gerundet = Math.round(kosten * 100) / 100;

event.value = gerundet.toFixed(2);
})();

Test: 1,5*0,35, he calculates 0,52 instead of 0,53..

Do you have an idea? I'm so confused that a simple thing like rounding is such a problem in this software 😞

Translate

try67

Community Expert

Rounding is actually a pretty challenging technical issue, related to the difficulty of floating point precision.

So the results of (1.5*0.35) in JS are actually 0.5249999999999999, which is why when you round it, it becomes 0.52, as it rounds down.

Translate

Bernd Alheit

Community Expert

What script do you use?

Translate

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.