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.
Hi Ash Wilks, what is it you're trying to achieve ? A standard average or a weighted average function ?
It seems like your "h" is already an average so its summary algorithm probably should be calculate not average
I agree with Peter, you should set the summary algorithm to "calculated", that should give you the right result.
