SUMOF(lines_section_identifier, '<field_API_name>')

Returns the sum of all the numbers in the given list of numbers. The numbers are identified by the API name of the field and the list is identified by the lines section identifier. Numbers include currency and percent field types also.

Target Field: Work Order > Total Parts Price (custom field)

Requirement: Set Total Parts Price to the sum of Discounted Line Price (custom field) of all the Parts lines section records.

Formula:

$F.SUMOF($D.Parts, ‘Discounted_Line_Price__c’)

AVGOF(lines_section_identifier, '<field_API_name>')

Returns the average of all the numbers in the given list of numbers. The API name of the field identifies the numbers, and the list is AVGOF(lines_section_identifier, '&lt;field_API_name ') identified by the lines section identifier. Numbers include currency and percent field types also.

Target Field: Work Order > Average Parts Price (custom field)

Requirement: Set Average Parts Price to the average Discounted Line Price (custom field) of all the Parts lines section records.

Formula:

$F.AVGOF($D.Parts, ‘Discounted_Line_Price__c’)

MINOF(lines_section_identifier, '<field_API_name>')

Returns the minimum of all the numbers in the given list of numbers. The numbers are identified by the API name of the field, and the list is identified by the lines section identifier. Numbers include currency and percent field types also.

Target Field: Work Detail (Labor) > Calculated Line Price (custom field)

Requirement: Set Calculated Line Price to Line Price Per Unit * Line Qty

Formula:

$F.MULTIPLY($D.Labor.SVMXC__Actual_Quantity2__c, $D. Labor.SVMXC__Actual_Price2__c)

MAXOF(lines_section_identifier, '<field_API_name>')

Returns the maximum of all the numbers in the given list of numbers. The numbers are identified by the API name of the field, and the lines section identifier identifies the list. Numbers include currency and percent field types also.

Target Field: Work Order > Maximum Parts Price (custom field)

Requirement: Set Maximum Parts Price to the maximum Discounted Line Price (custom field) of all the Parts lines section records.

Formula:

$F.MAXOF($D.Parts, ‘Discounted_Line_Price__c’)

COUNTOF(<recordCollection>, '<columnAPIname>')

Returns the count of all lines for the given record collection or section name. The list is identified by the section identifier. Passing column API is optional, provide this info to the get count of lines for the given column name having value.

Target Field: Work Order > Parts Requirement: Return the count of all the child lines for the Parts Detail Line section. Formula: $F.COUNTOF($D.Parts) Target Field: Work Order > Parts > Activity TypeRequirement: Return the count of all the child lines for the Parts Detail Line section. Additionally, it also returns the count of child lines for the Activity Type column name.

Formula: $F.COUNTOF($D.Parts,'SVMXC__Activity_Type__c')