About Excluding Lines from Reports

You can specify conditions to exclude generated lines from a report based on the contents of the line. You define the criteria for excluding a report line by adding a formula to column C of the line.

• Suppressing lines with zero values. To specify zero-line suppression, you type Z in column C. Financial Reporter suppresses all lines with a value of zero.

  If you do not want to suppress zeros on an individual line, but you specified Z in the default specification, type N in column C of the line you want printed.

• Using logical value formulas to include and exclude lines. You can place a logical value formula (TRUE/FALSE) in column C. If the formula in column C returns TRUE, Financial Reporter does not print the line. If the formula returns FALSE, the line is printed.

  For example, =G12 < F12 * 10% will check if the value in column F is less than 10% of the value in column G. If the statement is true, the line will be omitted from the report.

Note: Anything that appears in column C on a default specification line will be used by all subsequent lines unless you specifically override it.

Related Topics