Nov 27
Patrick Larkin Best way to compute this average?
Nov 27, 2013; 12:17
Patrick Larkin
Best way to compute this average?
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>
Nov 27
Jewett, Greg Re: Best way to compute this average?
Nov 27, 2013; 17:27
Jewett, Greg
Re: Best way to compute this average?
Nov 27
Brad Lindsay Re: Best way to compute this average?
Nov 27, 2013; 12:33
Brad Lindsay
Re: Best way to compute this average?
Nov 27
Patrick Larkin Re: Best way to compute this average?
Nov 27, 2013; 13:01
Patrick Larkin
Re: Best way to compute this average?
Nov 27
Brad Lindsay Re: Best way to compute this average?
Nov 27, 2013; 13:40
Brad Lindsay
Re: Best way to compute this average?
Nov 27
Tim Taplin Re: Best way to compute this average?
Nov 27, 2013; 11:58
Tim Taplin
Re: Best way to compute this average?
Nov 27
Steve Piercy - Web Site Builder Re: Best way to compute this average?
Nov 27, 2013; 13:32
Steve Piercy - Web Site Builder
Re: Best way to compute this average?
Dec 02
Patrick Larkin Re: Best way to compute this average?
Dec 02, 2013; 09:38
Patrick Larkin
Re: Best way to compute this average?
Dec 02
Steve Piercy - Web Site Builder Re: Best way to compute this average?
Dec 02, 2013; 06:45
Steve Piercy - Web Site Builder
Re: Best way to compute this average?
Dec 02
Patrick Larkin Re: Best way to compute this average?
Dec 02, 2013; 10:06
Patrick Larkin
Re: Best way to compute this average?
Dec 02
Steve Piercy - Web Site Builder Re: Best way to compute this average?
Dec 02, 2013; 07:11
Steve Piercy - Web Site Builder
Re: Best way to compute this average?
Dec 02
Patrick Larkin Re: Best way to compute this average?
Dec 02, 2013; 10:34
Patrick Larkin
Re: Best way to compute this average?
Dec 02
Steve Piercy - Web Site Builder Re: Best way to compute this average?
Dec 02, 2013; 08:24
Steve Piercy - Web Site Builder
Re: Best way to compute this average?
Dec 02
Patrick Larkin Re: Best way to compute this average?
Dec 02, 2013; 11:30
Patrick Larkin
Re: Best way to compute this average?