Does anyone know how to use average in dataview and get the grand total to average not sum when there are more than one row sort.
It seems like your "h" is already an average so its summary algorithm probably should be calculate not average
Hi Ash Wilks, what is it you're trying to achieve ? A standard average or a weighted average function ?
I agree with Peter, you should set the summary algorithm to "calculated", that should give you the right result.
Retrieving data ...