Wednesday, May 13, 2009

How to Print Negative Amounts in Red in FRx Reports

Many times when I teach FRx Reporting classes I am asked if FRx has a setting that will print negative amounts in red. FRx does not have that feature built into the software, but there is a work around you can use.

First, for the row that you want to print in red if the amount is negative, set the Print Control (Column F) to NP. Just below that row, you will need to insert two more rows that with a CAL function in the Format Code (Column C). See below:



The CAL formula in Row 1990 above gives the instruction to print the amount in this line if the amount on Row 1960 is less than zero. You will get the desired result if the amount was negative.

The formula in the next row, Row 2020, gives the instruction to print the amount in this line if the amount on Row 1960 is greater than zero. It is formatted to print in BLACK.

Save your Row Format, then be sure that the report is set to not print zero rows:



Your report should now give you the desired result.



- TJ Paulsen, Senior Project Consultant

0 Comments:

Post a Comment

Subscribe to Post Comments [Atom]

<< Home