Math Functions - Output Documents
Function Signature
Description
Example
ADD(number1,
number2
[,number3,...])
Adds all the numbers that are
passed as arguments to this function.
{{$F.ADD($D.Service_Quote.SVMXC__
Total_Line_Price2__c,$D.Service_
Quote.SVMXC__Discount__c)}} returns
the sum of Total Line Price field value and
Discount field value.
Note: Arithmetic operations can also be
directly achieved as illustrated below:
{{$D.Service_Quote.SVMXC__Total_Line_
Price2__c – ($D.Service_Quote.SVMXC__
Total_Line_Price2__c * $D.Service_
Quote.SVMXC__Discount__c/100)}}
SUMOF(target_
child_alias,child_
object_field_
name)
Adds the values of a child object
field to the target child
records. So, this is the sum of
a given column in the specified
record collection.
{{$F.SUMOF($D.Quote_Lines,'SVMXC__
Line_Price2__c')}} returns the sum of the
values of Line Price field in all the displayed
Quote Item records in the generated
output document.
$F.COUNTOF(<lines_section_identifier>, '<field_API_name>')
Returns the count of all lines for the given section. The list is identified by the lines section identifier. Passing field API is optional; use this to get the count of lines having value for the given column name.
$F.COUNTOF($D.Parts) returns the count of all the child lines for the Parts Detail Line section. $F.COUNTOF($D.Parts,'SVMXC__Activity_Type__c') returns the count of all the child lines for the Parts Detail Line section that has value on the Activity Type column.
Was this helpful?