The Expression engine (SQL) doesn’t allow to apply an aggregation function on top of another aggregation function.

Example :

Expression = AVG(SUM(ValueField_A))

This results in an error :
Cannot perform an aggregate function on an expression containing an aggregate or a subquery.

To solve this, you should leave only 1 level of aggregation functions (think about what you really want to calculate and test on a small dataset).

see also

Aggregated Expressions

Last modified: Sep 13, 2021


Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Post Comment