I can't figure out how to get an average and a maximum value of one field value within an advanced report (suggested syntax includes more than two fields separated by a comma which has confused me) - eg average property value within a set time period.
I have been playing around with add calculated field but my report isn't giving out. Perhaps i have to do a sum of all the values and then divide by the number of values - but I'm hoping Proclaim makes it easier.
Any advice gratefully received .
Solved a problem in an elegant manner and want to show off your code? Know a hard-to-find feature? Post it here for the benefit of others. Questions don't belong here.
1 post • Page 1 of 1