Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • 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

  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

  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