An average should include zero values. Otherwise it's not an average, it's some other calculation. But average aggregate functions and summary fields ignore empty values so if you defined a calculation field like this:
If ( yourfield ≠ 0 ; YourField )
You can take the average of this calculation field and get an "average" that ignores zero values.
Thanks Phil. Quick question, for my situation, does the formula need to be this to evaluate correctly:
If((DDay Between Deliveries / Gallons) ≠ 0 ; (DDay Between Deliveries / Gallons); "") //This puts a blank in the field instead of a 0
Or will it evaluate correctly the way you wrote it (which I guess would leave a 0 in the field?)
Your calc produces the same result. The ; "" can be omitted with no change to the results supplied so it's up to you which way you prefer to write the calculation.
Thank you Phil.