REVERSE ER function
The REVERSE function returns the specified list as a Record list value in reversed sort order.
Syntax
REVERSE (list)
Arguments
list: Record list
The valid path of a data source of the Record list data type.
Return values
Record list
The resulting list of records.
Example 1
If you enter data source DS of the Calculated field type, and it contains the expression SPLIT ("C|B|A", "|"), the expression FIRST( REVERSE( ORDERBY( DS, DS. Value))).Value returns the text value "C".
Example 2
If Vendor is configured as an Electronic reporting (ER) data source that refers to the VendTable table, the expression REVERSE (ORDERBY (Vendors, Vendors.'name()')) returns a list of vendors that is sorted by name in descending order.