EVALUATE function

EVALUATE(onerecord, value)

onerecordA record set consisting of a single record.
valueThe value to return. This may be any expression yielding a value.
Return:EVALUATE returns a single value.

The EVALUATE function returns the value evaluated in the context of the onerecord set (which must be a single record, only). This function typically uses indexing to select a single record for the onerecord recordset. The usage is to return a value from a specific child record when operating at the parent record's scope level. The advantage that EVALUATE has over using recordset indexing into a single field is that the value returned can be any expression and not just a single field from the child dataset.