If you enter different values for the same option in both your row set and column set, there is a conflict. Use the following table to determine which report object takes precedence, or to determine the behavior of the objects when a conflict exists:
| Option | Row Overrides Column | Column Overrides Row | Comments |
|---|---|---|---|
| Amount Type | N/A | N/A | Period Offset, Control Value, and Currency must be set at the same row or column level as the amount type. When you specify an amount type, you must also specify the period offset and any control values. |
| Offset | N/A | N/A | Amount Type, Control Value, and Currency must be set at the same row or column level as the Period Offset. |
| Control Value | N/A | N/A | Amount Type, Period Offset, and Currency must be set at the same row or column level as the Control Value. |
| Format | Yes | No | |
| Factor | Yes | No | |
| Display Zero | Yes | No | |
| Level of Detail | Yes | No | |
| Override Row/Column Calculations | No | Yes | A conflict exists only for those report cells where calculations are defined for both the intersecting row and column. |
| Activity (Dr, Cr, Net) | No | Yes | |
| Accounts | N/A | N/A | Report uses intersecting accounts |
| Summary | N/A | N/A | Must assign same summary option at row and column level |
| Currency | N/A | N/A | Amount Type, Period Offset, and Control Value must be set at the same row or column level as the Currency. |
| Change Sign | N/A | N/A | Yes overrides No |
| Change Sign on Variance | N/A | N/A | Yes overrides No |