Calculation Field Not Working - Sum and Average

Forum|Forum|1 year ago
November 14, 2024
3 replies
1487 views

Hi, I am a very new Adobe user and am trying to figure out how to have my Employee Review form auto calculate when the managers add their scores in.

I have 6 text fields that are formatted as Number, (Text Field Names: Safety Score, Quality Score, 5S Score, Productivity Score, CI Score, Attendance Score).

I have created a Total Points field, and an Average Points field, and tried to use the Calculate Tab, 'Value is the SUM of the following fields' and 'Value is the AVERAGE of the following fields' (respectively) and attempted to Pick the ones that I want used, but the selections that I make never stay selected when I hit okay.

I am not well versed in Java to try to write my own script.

Any assistance would be much appreciated! Thanks so much, Crystal.

Correct answer Nesa Nurani

I didn't have any issue adding calculation, here is your file with calculations added:

https://drive.google.com/file/d/17UFZFo002CqauqQ-YOb93vr-pUenmE9P/view?usp=sharing

K

kevin23813526ki5i

Known Participant

I'm having this same issue. It won't save anything I enter, from picking fields to custom javascript. @Nesa Nurani any ideas as to *why*?

Nesa Nurani

Community Expert

I don't know why this happens, you can try to reset your computer and try again, if you have same issue try to delete field and create new field.

K

kevin23813526ki5i

Known Participant

Yeah. I've updated the program, restarted the computer, created mulitple fields - all of them have the same issue. Some will occasionally accept an entry, but most won't, and the ones that do stop working once I try to change it. I cannot wait for a competitor to come along and offer an alternative to an expensive subscription that doesn't work and offers no legit support...

C

crystal_0975Author

Participant

PFP_Form_11-12-24_test1.pdf