JD Edwards Formula Maintenance for GXSALES

Use the following table to enter data in the Formula Builder > GXSALES panel:

Field	Description
Configuration	Click the drop-down list, and select the host configuration to be used. The list only displays configurations to which the user is authorized.
Total Field	Click the drop-down list, and select the field to be totaled.
Total Type	Click the drop-down list, and select the type of total to be calculated. Valid types are: `Average` `Count` `Maximum` `Minimum` `Summary`
Criteria 01-07	Click the drop-down list, and select the field(s) to be used as filtering criteria for the formula.
Value Cell	Specify the cell location containing the selection value for the corresponding criteria field.
Retrieve Data from Sales History File (F42119)	If selected, the formula retrieves data from the Sales History file (`F42119`). Otherwise, data is retrieved from the Sales Order Detail file (`F4211`).