Report Precedence

2 Minutes to read

Print
Dark
Light
PDF

Article summary

Did you find this summary helpful?

Thank you for your feedback

The following table provides information on report precedence such as how and when rows override columns or vice versa.

Functionality	Report Set Settings		Precedence/Expected Behavior
Functionality	Row Set	Column Set	Precedence/Expected Behavior
Conditional Format	Not configured	Configured	Conditional format always applied for column sets only.
	Configured	Configured	Conditional format always applied for column sets only.
	Configured	Not configured	n/a
Page Break	Configured	Configured	Page break applies to both the row and column.
	Configured	Not configured	Page break applies to the row.
	Not configured	Configured	Page break applies to the column.
Decimals (driven by number format)	Normal	Normal	If the number format is abs, then the format is not used on the row or column set. Decimal places configured on the row set will be applied to rows. No decimals will be applied to columns
	Normal	Absolute	Column takes precedence. Column format will be applied to columns. Row format will be applied to rows where there is no column format applied.
	Absolute	Normal	No decimal places applied to row or column. Default decimal places will be applied to the report.
	Absolute	Absolute	Column takes precedence. Default format applies to row and absolute format applies to column.
Amount Format	Normal	Normal	Format configured on the row set will be applied to row. Default format such as SAME applies to column.
	Normal	Absolute	Column takes precedence. Normal format applies to row. Absolute format applies to column. On overlapping cells, column takes precedence.
	Absolute	Normal	Default format such as SAME applies to column and row.
	Absolute	Absolute	Column takes precedence. Default format such as SAME applies to row. Format configured on column set applies to column.
Number Format	Normal	Normal	Format configured on row set will be applied to row. Default format applies to column
	Normal	Absolute	Column takes precedence. Format configured on row set applies to row. Format configured on column set applies to column. Column takes precedence on overlapping cells.
	Absolute	Normal	Default format (i.e. number format) applies to row and column.
	Absolute	Absolute	Column takes precedence. Default format applies to row. Format configured on column set applies to column.
Solve Order	Configured	Configured	Column takes precedence.
	Configured	Not configured	Applies to row.
	Not configured	Configured	Applies to column.
Report Set Excel Formulas	Excel formula added on row	Excel formula added on column	Column takes precedence. On column set line, the column formula is applied. On row set line, the row formula is applied.
Formula Exceptions	Exception formula added on row	Exception formula added on column	Column takes precedence. On column set line, the column formula is applied. On row set line, the row formula is applied.
Insert Formula	Insert formula added on row	Insert formula added on column	Formula added last takes precedence irrespective of row or column.
Other Combinations
	Excel formula	Formula exception	Column takes precedence.
	Excel formula	Insert formula	If insert formula is added last, it takes precedence otherwise the Excel formula applied takes precedence.
	Formula exception	Excel formula	Column takes precedence.
	Formula exception	Insert formula	If insert formula is added last, it takes precedence otherwise the formula exception applied takes precedence.
	Insert formula	Insert formula	Whichever is applied last takes precedence.
	Insert formula	Formula exception	If insert formula is added last, it takes precedence otherwise the formula exception applied takes precedence.
	Insert formula	Excel formula	If insert formula is added last, it takes precedence otherwise the Excel formula applied takes precedence.

Was this article helpful?

What's Next

Report Sets and Measures