A command to do more generally what we currently need AVGIF, SUMIF and COUNTIF to do.

Select records that meet some criteria and returns a list of those records.

Syntax:

SELECTIF( Criteria, [Linked Record Field] )

This would make it possible to do much more general calculations involving summaries of records, like calculating the standard deviation of a set of records with a certain status.