...
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
- In a Row Designer record select the Row Calculation row and click Options.
Image Added - The Row Options screen will be opened. Check the Override Column Calculation checkbox. Then click Ok.
Image Added - Save the row designer record.
- Print the report using that row designer record.
- 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
- In a Row Designer record select the Row Calculation row and click Options.
Image Added - The Row Options screen will be opened. Leave the Override Column Calculation checkbox unchecked. Then click Ok.
Image Added - Save the row designer record.
- Print the report using that row designer record.
- 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
Expand |
---|
|
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 Modified Image Modified Override Column Calculation is checked - Row formula will be used - In a Row Designer record select the Row Calculation row and click Options.
Image Modified - The Row Options screen will be opened. Check the Override Column Calculation checkbox. Then click Ok.
Image Modified - Save the row designer record.
- Print the report using that row designer record.
- This is how the report will look like when previewed/printed.
Image Modified
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 - In a Row Designer record select the Row Calculation row and click Options.
Image Modified - The Row Options screen will be opened. Leave the Override Column Calculation checkbox unchecked. Then click Ok.
Image Modified - Save the row designer record.
- Print the report using that row designer record.
- This is how the report will look like when previewed/printed.
Image Modified
The Column formula is C3 / C4. So to compute for the Cost Per Unit Net Income row: 740.00 / 61.00 = 12.13
|
Expand |
---|
|
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.
Override Column Calculation is checked - Row formula will be used - In a Row Designer record select the Row Calculation row and click Options.
- The Row Options screen will be opened. Check the Override Column Calculation checkbox. Then click Ok.
- Save the row designer record.
- Print the report using that row designer record.
- This is how the report will look like when previewed/printed.
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 - In a Row Designer record select the Row Calculation row and click Options.
- The Row Options screen will be opened. Leave the Override Column Calculation checkbox unchecked. Then click Ok.
- Save the row designer record.
- Print the report using that row designer record.
- This is how the report will look like when previewed/printed.
The Column formula is C3 / C4. So to compute for the Cost Per Unit Net Income row: 740.00 / 61.00 = 12.13
|
...