Does anyone know if its possible when calculating the averages to remove null values from the final average.
Example: I have 4 work orders in my database and there is a field called Trip Charge. There are only 2 out of the 4 that have a value in the Trip Charge field. When the program runs the average it goes by all 4 records.
All I want is the average of the ones that are actually filled in with a value.