Need help with stopping calculation field from rounding

Question

Hi,

I have a simple calculation field, which is averaging 5 fields together, and i have set the field to a number format with 2 decimal places. Now I realize that if you click on the number, it shows you the exact number, but I would like to have it display the real value to the 2nd decimal, without adding another decimal (which is the easiest way)

I have tried a custom calculation code with the math.round, math.ceil and (num).fixto(2) which I found from a few articles, but nothing is helping, so I was wondering if anyone had any other suggestions to try?

Bernd Alheit · Accepted Answer

hi there so I tried that, and it is rounding the decimal still.

so I have a field with the following custom calculation code:

// Initialize variables
var i, v, num = 0, sum = 0;
// Loop through the input fields
for (i = 1; i <= 13; i++) {
  v = +getField("A" + i).value;
  if (v !== 0) {
  // increment the non-blank/zero field counter
  num++;
  // add the field value to the running total
  sum += v;
  }
}
// Calculate the average
if (num) {
  event.value = sum / num;
} else {
  // All fields are empty, so set to blank
  event.value = "";
}

and set formatting to "none" so for this example the calculation came out to be: 2.7384615

I then created a field with this custom calculation:

event.value = this.getField("Overall Score").value.toFixed(2)

Formatting is set to "none" as well, and when I looked at the value it showed as: 2.74, but when I changed the code to ".toFixed(3)" it displayed the value as 2.738

I am not sure what is going on, or why its still rounding when set to 2.

Try this:

event.value = (this.getField("Overall Score").value - 0.005).toFixed(2);

try67 · Answer

Remove the Format option and round the value in your calculation script, using toFixed(2), not fixto(2), which doesn't exist.

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.

Scanning file for viruses.

This file cannot be downloaded