I have to compute an average based on 9 fields that either have a value from 0-3 or nothing. If the field contains nothing (not zero), it needs to be removed from the average computation. For instance:

value1 = 1
value2 =
value3 = 3
value4 = 0
value5 = 1
value6 = 2
value7 =
value8 = 0
value9 = 3

The correct computation would be `10/7 or 1.43

All of these values would be stored in a single record. I'd need to test for emptiness, calculate a sum, and a divisor. Is there a short way anyone can think of to do this?



Patrick Larkin
Information Systems
Bethlehem Area School District
https://www.beth.k12.pa.us





#############################################################
This message is sent to you because you are subscribed to
the mailing list Lasso
Lasso@lists.lassosoft.com
To unsubscribe, E-mail to: <Lasso-unsubscribe@lists.lassosoft.com>
Send administrative queries to <Lasso-request@lists.lassosoft.com>