Average formula with null
I have 6 Formula Numeric Fields that Return a numeric number is a percent format... This is working just fine. But now I need to find the overall average for these 6 Fields that return a percent. But...
Forum Discussion
Have you set the field properties for each of the score fields to not treat null as zero? The Average function will ignore nulls, which is what you want