In our custom module (Applicants), we have 8 picklist fields (values between 1-5, whole numbers and decimals). We’d like for those fields to be averaged and the average value inputted automatically into a different field, Interview Score (decimal field).

We initially had the Interview Score field as a formula field, but the output for the average was not accurate.

Is there a function that could average these fields and enter the value in the Interview Score field? I've tested a couple of potential example functions that I found, but none were accurate, so I deleted them.