About Verifying Account Data
You can use two methods in Financial Reporter to test account information to decide whether it should appear in a report.
- Use
a formula in column C to test the contents of a line. You can specify conditions for excluding generated lines from a report
based on the contents of the line.
For more information, see About Columns in Report Specifications.
-
Use FR functions with spreadsheet functions. Financial Reporter functions can replace parameters of spreadsheet functions, so you can test the contents of fields before printing the report, or manipulate them as you wish.
To specify that a balance is printed only if it exceeds 6000, use =IF(FRAMT("BALP","1000")>6000,FRAMT("BALP","1000"),0).
To print the average value of two accounts, use =AVERAGE(FRAMT("BALP","1000"),FRAMT("BALP","2000")).