INFORMATIONAL ** THIS INFORMATION HAS NOT BEEN VERIFIED **

How to use the SORT and ASORT functions in FRx

Entry Type: Informational

Product: FRx

Application: FRx Desktop

Version Reported: 6.7

Subject:

How to use the SORT and ASORT functions in FRx

Possible Resolution:

These codes sort expenses or revenues, sequence an actual or budget variance report by the largest variance, or sort the row descriptions alphabetically. The SORT code sorts the report in ascending or descending order based on the value in a selected column.

To use the SORT code

1. Select the SORT format code in the Row Format
2. Enter the range of rows to be sorted in the Related Rates/Rows/Unit column.
3. Enter the Column Layout column letter to be used for the sort in the Column column.
4. The report is sorted in ascending order by default. For descending order, enter a negative sign (-) before the column letter.

The ASORT code sorts the report by the absolute value of the value in the selected column. In other words, the sign of the value is ignored in the sort. This format code shows values sequenced by the magnitude of the variance, whether positive or negative.

To use the ASORT code

1. Select the ASORT format code in the Row Format
2. Enter the range of rows to be sorted in the Related Rates/Rows/Unit column.
3. Enter the Column Layout column letter to be used for the sort in the Column column.

The report is sorted in ascending order by default. For descending order, enter a negative sign (-) before the column letter. Note: Do not include formatting or total rows in a sort calculation. If you include format or total rows, Microsoft FRx sorts these rows along with the general ledger rows.