Participant

Question

Need help creating custom calculation script in Adobe Acrobat Pro

Forum|Forum|9 years ago
September 15, 2016
2 replies
552 views

I am creating a fillable form for a college midterm grading rubric. I have the totals adding up, getting divided by 15 (number of questions) to give me my average. Then, I have a table with corresponding percentages based on what the average score is. I need to create a custom calculation script to do an if/then situation. "If your average score is 1.9, then your percent is 97%". However, when I divide the total by 15 I am often left with a number that has many decimals. I really don't want to have to go in and type in every possible decimal point in order for the percentage calculations to come out correctly. Is there a way to do a if/else if situation like "If average is between 1.7 and 1.79, then your percentage is 91%"?

Hopefully this makes sense and thank you in advance for any suggestions!

This topic has been closed for replies.

G

George_Johnson

Inspiring

Yes, there is a way to do that using an if/else if/else statement, no rounding needed. If you post your current script I can suggest a revision.

L

laurens6820332Author

Participant

Hi George,

This is the current script I'm working with. It originated on something that I was dividing by 10 instead of 15. That made the decimal count go down significantly. For example: if my Average_Score is 1.7222222222 I would need the output value to read as 91%. Thank you!

var v = this.getField("Average_Score").valueAsString;

if (v=="2") event.value = "100%";

else if (v=="1.95") event.value = "100%";

else if (v=="1.9") event.value = "97%";

else if (v=="1.85") event.value = "97%";

else if (v=="1.8") event.value = "94%";

else if (v=="1.75") event.value = "94%";

else if (v=="1.7") event.value = "91%";

else if (v=="1.65") event.value = "91%";

else if (v=="1.6") event.value = "88%";

else if (v=="1.55") event.value = "88%";

else if (v=="1.5") event.value = "85%";

else if (v=="1.45") event.value = "85%";

else if (v=="1.4") event.value = "82%";

else if (v=="1.35") event.value = "82%";

else if (v=="1.3") event.value = "79%";

else if (v=="1.25") event.value = "79%";

else if (v=="1.2") event.value = "76%";

else if (v=="1.15") event.value = "76%";

else if (v=="1.1") event.value = "73%";

else if (v=="1.05") event.value = "73%";

else if (v=="1") event.value = "70%";

else if (v=="0.95") event.value = "70%";

else if (v=="0.9") event.value = "63%";

else if (v=="0.85") event.value = "63%";

else if (v=="0.8") event.value = "56%";

else if (v=="0.75") event.value = "56%";

else if (v=="0.7") event.value = "49%";

else if (v=="0.65") event.value = "49%";

else if (v=="0.6") event.value = "42%";

else if (v=="0.55") event.value = "42%";

else if (v=="0.5") event.value = "35%";

else if (v=="0.45") event.value = "35%";

else if (v=="0.4") event.value = "28%";

else if (v=="0.35") event.value = "28%";

else if (v=="0.3") event.value = "21%";

else if (v=="0.25") event.value = "21%";

else if (v=="0.2") event.value = "14%";

else if (v=="0.15") event.value = "14%";

else if (v=="0.1") event.value = "7%";

else if (v=="0.05") event.value = "7%";

else if (v=="0") event.value = "0%";

G

George_Johnson

Inspiring

Try something like this:

// Get the field value, as a number

var v = +getField("Average_Score").value;

// Set this field value based on the number

if (v >= 1.95) event.value = "100%";

else if (v >= 1.85 && v < 1.95) event.value = "97%";

else if (v >= 1.75 && v < 1.85) event.value = "94%";

// etc.

G

gkaiseril

Inspiring

You have to round the result. This can be done using the "Format" option of "Number" and specifying the number of zeros. This will round up. You could also force the value of the field to the rounded value using the "util.printf" method. This too will round up. You can use the Math.ceil and Math.floor methds to not round but go tot the nest larger value or truncate the value.

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