Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Note
Community interest groups have now moved from Yammer to Microsoft Viva Engage. To join a Viva Engage community and take part in the latest discussions, fill out the Request access to Finance and Operations Viva Engage Community form and choose the community you want to join.
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.