Calculated fields - average and maximum

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.
Post Reply
Jacqueline
Posts: 83
Joined: Fri May 25, 2012 2:40 pm
Has thanked: 14 times

Calculated fields - average and maximum

Post by Jacqueline » Sat Jan 23, 2016 6:23 pm

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 .

Post Reply