Setting up the Change Base Row (CBR) function in FRx

Entry Type: Informational

Product: FRx

Application: FRx

Version Reported: 6.0

Subject:
Setting up the Change Base Row (CBR) function

Possible Resolution:

The CBR (Change Base Row) code defines the base row for columns that calculate a percentage of or multiply by the base row for each row in the report.  Enter the allocation base row in the Related Rates/Rows/Unit column.  This base row is used for the calculation and remains in effect until another CBR row is defined.  The CBR code must be placed above all rows for which the CBR will be used in the calculations denominator. Multiple CBR rows may be defined within one report.

The following figure illustrate the CBR  format code.  In the row format, the CBR code is in row 45.  The Related Rates/Rows/Unit column of row 45 shows row 140, which is the Net Sales row.

The calculation formula in column C is B/BASE and a special format mask.  This instructs FRx to divide the amount in column B by the amount in column B of the base row (row 140) and to put the result in column C of that row.  The result is that each amount in Column C is the amount in Column B expressed as a percentage of net sales. 

Using Base Row in Row Format Window:

Using Base Row in Column Layouts Window

To create a base row percentage:

  1. On the File menu, point to New and click Row, or open existing Row Format.
  2. Enter CBR in the Fmt Code cell of the appropriate row.
  3. Enter the row code for the base item to be used in the calculations denominator in the Related Rates/Rows/Unit cell.
  4. On the File menu, click Save.
  5. On the File menu, point to New and click Column, or open existing Column Layout.
  6. Double-click the Type cell and click Calc to create a calculation column.
  7. In the Calc Formula cell, enter the letter of the column to use in the calculation followed by the division sign and the word Base
    Example: B/BASE 
  8. In this example, every number in column B is divided by the number in the specified base row, and the resulting percentage is placed in the specified column.
  9. On the File menu, click Save.