It looks like you want all the calculations.
I would add the "Optional" value to the selections in the drop down box.
Then one can use the first calculation option of "Field is the ____ of the following fields:" to assign the numerical score, sum the numerical scores, and average the numerical scores in the appropriate fields.
It already calculates sum and average. I need a script that returns and overall score based on the criteria. I'm super new to java can you help? Baby instructions please
What is the total Numerical Rating or Average when one or more of the critical elements is 0 or unacceptable?