Previous  Next          Contents  Index  Navigation  Glossary  Library

Row and Column Overrides

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:

Row Set vs. Column Set Override Summary

Row Set vs. Column Set Override Summary
Option Row Overrides Column Column Overrides Row Comments
Amount Type Yes No  
Offset Yes No  
Control Value Yes No Must assign same currency, budget or encumbrance type at row and column level
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 Must assign same currency to intersecting rows and columns; otherwise 0 (zero) appears in place of an amount.
Change Sign N/A N/A Yes overrides No
Change Sign on Variance N/A N/A Yes overrides No

         Previous  Next          Contents  Index  Navigation  Glossary  Library