amerifax
Technical User
- Dec 28, 2006
- 37
Based on the above message on finding the total, we are also trying to come up with an average. How would the average work. One of the fields gives the weight of the car and it runs by the year. Each year we have a different weight over a three year period. We want to come up with the average for the three years. We have added a field in each record to carry the value called tot_avg. This is how you would think the logic would show:
If weight in years 2002, 2003, 2004 is greater than 1000 put average in tot_avg the 1000 is to eliminate using an average of less than 1000 pounds. So if we have 1 year at 900 pounds, the 2nd at 1500 lbs and the 3rd at 1500 lbs. The average would be 1500 lbs eliminated the 900.
Thanks for taking the time to look this over.
Bob Snow
If weight in years 2002, 2003, 2004 is greater than 1000 put average in tot_avg the 1000 is to eliminate using an average of less than 1000 pounds. So if we have 1 year at 900 pounds, the 2nd at 1500 lbs and the 3rd at 1500 lbs. The average would be 1500 lbs eliminated the 900.
Thanks for taking the time to look this over.
Bob Snow