Page History

The Override Column Calculation checkbox from the Row Options screen is used to dictate what formula to use in case the Row Calculation type of row meets with Column Calculation type of column.

• Override Column Calculation is checked - This will use the Row formula. 
• Override Column Calculation is unchecked - This will use the Column formula.

To explain how this option works, let's take this illustration below.

Image Added

Image Added

Override Column Calculation is checked - Row formula will be used

1. In a Row Designer record select the Row Calculation row and click Options.
   Image Added
2. The Row Options screen will be opened. Check the Override Column Calculation checkbox. Then click Ok.
   Image Added
3. Save the row designer record.
4. Print the report using that row designer record.
5. This is how the report will look like when previewed/printed.
   Image Added
   
   The Column formula is R2 - R3. So to compute for the Cost Per Unit Net Income row:
   11.29 - 10.00 = 1.29

Override Column Calculation is Unchecked - Column formula will be used

1. In a Row Designer record select the Row Calculation row and click Options.
   Image Added
2. The Row Options screen will be opened. Leave the Override Column Calculation checkbox unchecked. Then click Ok.
   Image Added
3. Save the row designer record.
4. Print the report using that row designer record.
5. This is how the report will look like when previewed/printed.
   Image Added
   
   The Column formula is C3 / C4. So to compute for the Cost Per Unit Net Income row:
   740.00 / 61.00 = 12.13