Previous	Next		Contents	Index	Navigation	Glossary	Library

Row Name: Use this name to reference this row when defining calculations or using other forms. This name does not appear on any reports.

Note: If you plan to use row names in calculations, make sure the row names are unique within the row set.

Percent of Row: Enter a value for a percentage column. This value is the sequence number of the row you want to use as the percentage denominator. For example, if you want to define the report below, enter the sequence number of the total sales row (40) in the Percent of Row field for every row. Then in your column set, define a calculation column which calculates percent on the sales column, using the operator % and the column sequence 10.

		Column 10	Column 20
		Sales	% of Total Sales
Row 10		100	10
Row 20		400	40
Row 30		500	50
Row 40 (Total)		1000	100

Override Column Calculations: Select this option if you want your row calculation to take precedence over any conflicting column calculations. For example, you may define a column that is the sum of the other columns in your column set and a row set that has a gross margin percentage row. However, since the gross margin percentage in the total column is not the sum of the percentages in each column, you should override the column calculation.

See Also

Defining Row Sets

Defining Report Calculations

Assigning Control Values