Cells
You can modify cells in rows to override the column or row calculations for a particular cell. You can modify cells in any row except when the row is defined as a title row (row type = TIT). Rows defined as a single account or an account group row (row type = GAC or SAC) enable you to apply a function to the cell when the column that includes the cell is defined as a function column. Rows that are defined as a formula row (row type = FOR) enable you to apply a formula to the cell when the column is defined as a function or a formula column.
This table shows the cell overrides:
Row Type |
Function Column |
Formula Column |
---|---|---|
Single Account or Group Account |
Can override column function with a cell function |
Cannot override column formula |
Formula |
Can override the row formula with a cell formula |
Can override both the row and column formulas with a cell formula |