Greetings all,
I have 3 columns of info in a MI table as follows
Capacity 1 Capacity 2 Capacity 3
Site 1 10 30 10
Site 2 0 10 0
Site 3 10 0 20
and I want to work out for every row the average of the 3 capacities but ignoring the
0's in any of the columns.
Therefore results would be in a new column
Avg Capacity
Site 1 16.7
Site 2 10
Site 3 15
HAs anyone come accross a solution for this problem.
Thanks
Tony
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
