Cross Tab Fields

Field Name

The name of the field being edited.

Field Type

The field type. For rows and columns this may be Numeric, Character or Date. Summarised fields are always set to numeric.

Group By

If you specify a Date Field Type on a row or column you can also specify the date grouping to use. These include:

Daily	Create one row or column per day.
Weekly	Create one row or column per week.
Half Monthly	Create one row or column for the 1st and 2nd half of each month.
	The split will occur on the middle day of the month depending on
	the length of the month.
Quarterly	Create one row or column for each quarterly period. Quarters are
	set as months 1-3 (January-March), 4-6 (April-June),
	7-9 (July-September) and 10-12 (October-December).
Half Yearly	Jan-June and July-December split
Annually	Creates one row or column per year.

Round

Applies only to the first summarised value. Cross tab data will be rounded to the number of decimal places specified here. The default setting is 2 decimal places.

Calculation

The type of calculation to perform. Options include:

Sum	Add the result of each calculation to the total.
Minimum	Calculate the smallest value.
Maximum	Calculate the highest value.
Count	Count the number of entries.

Equation

The field or expression to base the calculation of the summarised value on. The numeric result of the calculation is used. Equations do not apply to rows or columns.

For example, to show a row of invoice totals, the expression would be:

Invoice->Invtot

If a single field does not represent the calculation you wish to perform, you can enter CAPITAL Business Script. For example:

Contents->Soldfor * AsVal(Contents->Qty)

The above expression multiplies the invoice contents sale item "sold for" unit price by the number of units sold, and returns the extension or total sell line item sell price.

Test...

Press this button to check if the equation's result is valid.

____________________________