{{tag>Known_Issues, Issue:Min, Issue:Max, Issue:Avg, Issue:Sub_Query, Issue: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 ====

<grid>
<col sm="1"><invisible> This is a spacer column</invisible></col>

<col sm="5">===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:<code aim>FIND Account WHERE  (COUNT Transaction WHERE (MAX.Transaction.Amount = 1000)) </code> </col>

<col sm="1"><invisible> This is a spacer column</invisible></col>

<col sm="5">===Work Around===
Avoid using these expressions in subqueries
</col>
</grid>