ADD(value1, value2)

Adds two numeric values. The values can be numbers or field identifiers of numeric fields (number, currency, percent).

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

Requirement: Set Total Parts Labor Price to the sum of Total Parts Price and Total Labor Price (both custom Work Order fields).

Formula:

$F.ADD($D.Work_Order.Total_Parts_Price__c, $D.Work_Order.Total_Labor_Price__c)

SUBTRACT(value1, value2)

Subtracts value2 from value1. The values can be numbers or field identifiers of numeric fields (number, currency, percent).

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

Requirement: Subtract 5 from Total Parts Labor Price.

Formula:

$F.SUBTRACT($D.Work_Order.Total_Parts_Labor_Price__c, 5)

MULTIPLY(value1, value2)

Multiplies value1 by value2. The values can be numbers or field identifiers of numeric fields (number, currency, percent).

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)

LESSTHAN(value1, value2)

Compares the two arguments and returns TRUE if value1 is less than value2. Returns FALSE if value1 is equal to or greater than value2. The field type of the arguments must be the same.

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

Requirement: If Discounted Line Price is less than 10.45, set it to 10.45; else, leave Discounted Line Price unchanged.

Formula:

$F.IF($F.LESSTHAN($D.Labor.Discounted_Line_Price__c, 10.45), 10.45, $D.Labor.Discounted_Line_Price__c)

DIVIDE((value1, value2))

Divides the dividend by divisor (dividend / divisor). The values can be numbers or field identifiers of numeric fields (number, currency, percent).

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

Requirement: Set Calculated Line Price to half of its value.

Formula:

$F.DIVIDE($D.Labor.Calculated_Line_Price__c, 2)