Testing Field Information Before Printing
The Financial Reporter provides several ways that you can test account information to decide whether it should appear in a report.
Test the contents of the line using a formula in column C. Financial Reporter lets you specify conditions for excluding generated lines from a report based on the contents of the line. See the next section for details on using selection criteria in column C of a financial report.
Use FR functions with spreadsheet functions. Financial Reporter functions can replace parameters of spreadsheet functions, and vice versa, so you can test the contents of fields before printing the report, or manipulate them as you wish.
For example, you can include formulas like this in Financial Reporter cells (where the balance is printed only if it exceeds 6000; otherwise, the program reports a 0 amount):
=IF(FRAMT("BALP","1000")>6000,FRAMT("BALP","1000"),0)
or ones like this example (which prints the average value of the two accounts):
=AVERAGE(FRAMT("BALP","1000"),FRAMT("BALP","2000"))
See also