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
Can you think of a change to your formula to calculate to null under the condition you don't want to include in the the average?
can say in plain english under what conditions you want the above formula to calculate to null?
ie, you need to differentiate, I assume, between a zero score and a null score.
can say in plain english under what conditions you want the above formula to calculate to null?
ie, you need to differentiate, I assume, between a zero score and a null score.