Function

Description

SUM()

Returns the total values in the field you select in the Field to Aggregate option.

Use: 

${SUM(Object.RelationName["FieldName"])}

Example:

${SUM(Object.Items["Qty"])}

AVG()

Return the average value in the field you select in the Field to Aggregate option.

Use: 

${AVG(Object.RelationName["FieldName"])}

Example:

${AVG(Object.Opportunity["Amount"])}

MIN()

Return the lowest value of the field you select in the Field to Aggregate option for all directly related records.

Use: 

${MIN(Object.RelationName["FieldName"])}

Example:

${MIN(Object. RelationName ["FieldName"])}

MAX()

Return the highest value of the field you select in the Field to Aggregate option for all directly related records.

Use: 

${MAX(Object. RelationName ["FieldName"])}

Example:

${MAX(Object.Opportunity["ClosedDate"])}

COUNT()

Returns the total number of related records.

Use: 

${COUNT(Object.RelationName["FieldName"])}

Example:

${COUNT(Object.Opportunity["Stage = Won"])}

FIRST()

Returns the first record of the field you select in the Field to Aggregate option for all directly related records.

Use: 

${FIRST(Object.RelationName["FieldName"])}

Example:

${FIRST(Object.Activity["ActivityDate"])}

LAST()

Returns the last record of the field you select in the Field to Aggregate option for all directly related records.

Use: 

${LAST(Object.RelationName["FieldName"])}

Example:

${LAST(Object.Case["OpenDate"])}