I have a need for a group of fields to be averaged and have the average value displayed in a separate field. There are 12 available fields but data is not required to be entered for each field. Instead of averaging on the 12 fields, I need to be able to average based on the number of fields that have a value in them. I was working with the avg() function where I created a group for the 12 fields but i am stuck on if there is a way to count the fields that have data.
In my head i would like to do something like (Field1 + Field2 + Field3 + ...)/ (count of fields that have data) but I don't know how to complete the second portion.
The attachment just has three fields with the fourth field having an avg function for the group that contains the 3 fields.
Thanks,
Jason