How can you calculate weighted averages?
21 March, 2013
I need to calculate the weighted average cost per square metre of property, across a range of records. I can't seem to find a formula that allows me to calculate the weighted average - only the arithmetic mean or the weighted moving average. Is there a way I can do this in report builder without calculating a field?
Hi,
Unfortunately , the only way to do this at the moment is to use one of the following methods;
-Freehand SQL Report
-Freehand Calculated Field (view level)
-Calculated field (report level)
-Write your own analtyic function
Please let us know how you go.
Regards,
David
Unfortunately , the only way to do this at the moment is to use one of the following methods;
-Freehand SQL Report
-Freehand Calculated Field (view level)
-Calculated field (report level)
-Write your own analtyic function
Please let us know how you go.
Regards,
David