The average summary method and aggregation function [Average:] both include zero values when calculating an average.
This makes sense but sadly means that in almost all scenarios the irritating workaround of counting non-zeros and then dividing is required. This costs line items (and therefore space), increases calculation complexity and takes time.
Hopefully, there is a way of augmenting the current average function because where every line item is precious, counting non-zeros is more than irritating, it is not possible.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.