Filter

A filter is a specific numeric range that you can identify for the Report Writer application to include or exclude from a column when you define a format. For example, you can exclude accounts with an ending balance of 0 to prevent accounts without an ending balance from printing on the report.

Filtering affects only retrieved values, such as amount and units. The values you filter must be numeric, and filters can only be used on columns that use numeric data dictionary names.

Example

LGE has created a report to compare last year's expense amounts with this year's expense amounts. To help with analysis, they want to see only those accounts where expenses have remained level or increased. To create such a report, they filter the column that holds the calculated difference between the two years. The filter includes only lines where the difference is between 0 and 999,999,999.