How do I exclude accounts from a range in FR?
You can specify selection criteria on a default specification line, on individual specification lines, and in formulas. With all these possibilities for account selection, you must be very clear which criteria are actually in effect.
Accounts must meet restrictions and criteria specified on the FR View form
The first restriction you place on account selection is with the FR View form (or with the Print Financial Statements form). Report-level account range filtering is in effect for any account reference that specifies a range of accounts.
Overriding account ranges
You can override FR View form ranges in two ways:
-
By specifying segment codes that are outside the ranges defined in the FR View form.
-
By using the “$” prefix in particular account number references.
Unless you override the FR View form, accounts must both fall within the specified range and meet other criteria specified on the View form.
Overriding default lines
If you specify any selection criteria in column B of a default specification line, that criteria is in effect unless you override it.
Overriding line criteria
You can override the criteria on a single line by placing a new criteria expression in column B. The criteria expression is in effect only for the line on which you define it. If you specify a criteria for a single formula in the line, the line criteria is ignored.
See also