Sorting codes sort accounts, values, sequence an actual or budget variance report by the largest variance, or sort the row descriptions alphabetically. The following sorting codes are available:

  • SORT– Sorts the report in ascending order, based on the values in the specified column.

  • ASORT– Sorts the report by the absolute value of the values in the specified column in ascending order. In other words, the sign of each value is ignored in the sort. This format code sequences the values by the magnitude of the variance, whether positive or negative.

  • SORTDESC– Sorts the report in descending order, based on the values in the specified column.

  • ASORTDESC– Sorts the report in descending order by the absolute value of the values in the specified column.

Specify a sorting code

  1. In Report Designer, click Row Definitions, and then open the row definition to modify.

  2. Double-click the Format Codecell, and then select a sorting code.

  3. In the Related Formulas/Rows/Unitscell, type the range of row codes to sort. To specify a range, enter the first and last row codes separated with a colon. For example, 160:490specifies the range 160 through 490.

  4. In the Column Restrictioncell, type the letter of the report column to be used for the sort.

    Note Note

    Include only amount rows in a sort calculation.

Example

The following building block example shows an ascending sort on the values in column D of the report for rows 160 through 490. It also shows how a descending sort on the absolute values in column G of the report for rows 610 through 940 is set up.

Row Code

Description

Format Code

Related Formulas/Rows/Units

Normal Balance

Column Restriction

Link to Financial Dimensions

100

Sorted by Monthly Variance in Ascending Order

DES

 

 

 

 

130

 

SORT

160:490

 

D

 

160

Sales

 

 

C

 

4100

190

Sales Returns

 

 

 

 

4110

 

...

 

 

 

 

 

490

Interest Income

 

 

C

 

7000

520

 

DES

 

 

 

 

550

Sorted by YTD Absolute Variance in Descending Order

DES

 

 

 

 

580

 

ASORTDESC

610:940

 

G

 

610

Sales

 

 

C

 

4100

640

Sales Returns

 

 

 

 

4110

 

...

 

 

 

 

 

940

Interest Income

 

 

C

 

7000

The report resembles the following illustration:

Variance Analysis (Sorted by Variance)

Beijing and Atlanta Regions

For the Seven Months Ending July 31, 2007

July

YTD

 

Actual

Budget

Variance

Actual

Budget

Variance

Sorted by Monthly Variance in Ascending Order

COGS

873,872

236,144

(637,728)

4,864,274

1,590,315

(3,273,959)

Salaries and Wages

97,624

65,573

(32,051)

653,884

441,664

(212,220)

Sales Discounts

36,383

24,152

(12,231)

241,562

162,670

(78,892)

Sales Returns

10,917

7,246

(3,671)

62,809

48,803

(14,006)

Rent Expense

12,052

9,019

(3,033)

80,444

60,748

(19,696)

Office Expense

5,023

3,291

(1,732)

33,420

22,098

(11,322)

Travel Expense

7,656

7,641

(15)

51,062

51,469

407

Sales

1,240,119

410,389

829,730

7,139,288

2,764,549

4,374,739

Sorted by YTD Absolute Variance in Descending Order

Sales

1,240,119

410,389

829,730

7,139,288

2,764,549

4,374,739

Travel Expense

7,656

7,641

(15)

51,062

51,469

407

Office Expense

5,023

3,291

(1,732)

33,420

22,098

(11,322)

Sales Returns

10,917

7,246

(3,671)

62,809

48,803

(14,006)

Rent Expense

12,052

9,019

(3,033)

80,444

60,748

(19,696)

Sales Discounts

36,383

24,152

(12,231)

241,562

162,670

(78,892)

Salaries and Wages

97,624

65,573

(32,051)

653,884

441,664

(212,220)

COGS

873,872

236,144

(637,728)

4,864,274

1,590,315

(3,273,959)

See Also