Aggregate function on a set of aggregate functions

[#1]

Hi all,

Quick question, I am trying to get the max value from multiple counts/freqs.I tried something like the below but it doesn't work.

Any ideas?

= Max(

Count(field1),
Count(field2),
Count(field3)
)

Regards

Revlin

[swuehl · Accepted solution]

Try

= RangeMax(

Count(field1),
Count(field2),
Count(field3)
)

[#3]

That works, thanks