I’m trying to make a scorecard where there are different categories to score on. For example Creativity, Production Value, Personal Favorite. On the form judges add from a dropdown their different scores between 1-10.
In the workflow I want to take all those different scores and average them. I could not find an easy way to do this, so I created a new field which was a list of numbers. I added each number to this list and then average the list. I thought this would work, but then I noticed if there are two of the same numbers it would only add that number once, and as you can imagine this would break the average.
This solution was a lot of work having to add all the different fields to the list one at a time. Is there not an easier way to just look at the different field values and get an average? Am I missing something?