ref:b_i:function_limitations_in

Known Issues,, Min,, Max,, Avg,, Sub Query,, Query

<invisible> This is the template for INHERITED known issues pages - add a tag to Issue: to allow this to show on the tagged page</invisible>

Function Limitations In Subqueries

<invisible> This is a spacer column</invisible>

===Problem/Limitation Description=== MIN, MAX and AVG expressions are not supported if used in subqueries on groups. For example the following query is not supported if Transaction is a group:

FIND Account WHERE  (COUNT Transaction WHERE (MAX.Transaction.Amount = 1000))

<invisible> This is a spacer column</invisible>

===Work Around=== Avoid using these expressions in subqueries