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.
Posts: 105
Joined: Fri May 25, 2012 2:40 pm
Has thanked: 17 times

Calculated fields - average and maximum

Post by Jacqueline »

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 two fields 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 .

Posts: 463
Joined: Fri Jun 15, 2012 12:44 pm
Has thanked: 15 times
Been thanked: 46 times

Re: Calculated fields - average and maximum

Post by revellbikes »

I'm my experience Calculated fields are more trouble than they're worth.

If you're struggling to get them working, I'd suggest going with a Maths field and then add this to your report or do the calculation outside of Proclaim in Excel.

I'm not the biggest advocate of Calculated fields as you can probably tell, someone else might be able to help further with them but I've always opted for an alternative due to their poor design, lack of flexibility and no syntax checker.