A bit verbose …
Let ( [
theCount = GetAsBoolean ( R1 ) + GetAsBoolean ( R2 ) + GetAsBoolean ( R3 ) + GetAsBoolean ( R4 ) + GetAsBoolean ( R5 ) ;
theSum = R1 + R2 + R3 + R4 + R5
Case ( theCount ; theSum / theCount )
Putting a null "" value instead of a 0 would make it work but, depending on what else you use the fields for it could cause other problems.
Verbose is fine as long as it works...and it works perfectly! Thanks.
Thanks for the link.