I am creating some calculated fields that add together and average up to twelve numbers, but in several cases it may be fewer numbers but there will still be twelve columns. Is there a simple way to get a sum and average without replacing nulls with 0? I need the null so that the average is correct.
Thanks!
