a!customFieldSum_26r9 Function

Function

a!customFieldSum_26r9( value )

Used to create a real-time custom record field, this function returns a sum of values. You can calculate the sum of record fields, related record fields, or literal values of type Number (Integer) or Number (Decimal Floating).

Parameters

Usage considerations

Where to use this function

The a!customFieldSum_26r9() function can only be used to create a custom record field that evaluates in real time. This means you can reference related record fields, constants, and other supported functions in your calculations.

To create a custom record field that evaluates in real-time:

1. In your record type, go to Data Model.
2. Click NEW CUSTOM RECORD FIELD.
3. From SELECT A TEMPLATE, choose Write Your Own Expression.
4. Choose Real-time evaluation.
5. Click NEXT.

6. Enter an expression using any Custom Field function.

   Note:  Custom record fields that evaluate in real-time must use at least one Custom Field function.

7. Click NEXT.
8. Enter a Name for your custom record field.
9. Click CREATE.
10. Click SAVE. The new custom record field appears in your list of fields.

Use with other Custom Field functions

You can use the a!customFieldSum_26r9() function in conjunction with other Custom Field functions, like a!customFieldSubtract(), a!customFieldDivide(), or a!customFieldMultiply() to create the calculations you need.

See the Real-time evaluation recipes for an example.

Example

Let's say you want calculate each employee's total salary, which includes their base salary, restricted stock units (RSU), and an annual bonus that is only applied if they qualify.

On the Employee record type, you could create a custom record field that evaluates in real-time so you can add the baseSalary field, the related record field rsuDollarAmount, and the related record field annualBonus. However, the annualBonus field will only be included in the calculation when the constant cons!DISCRETIONARY_BONUS is true.

1
2
3
4
5
6
7
8
9
10
11
a!customFieldSum_26r9(
  value: {
     recordType!Employee.fields.baseSalary,
     recordType!Employee.relationships.employeeLevel.fields.rsuDollarAmount,
     /* If the constant is true, then add a discretionary bonus */
     if(cons!DISCRETIONARY_BONUS, 
        recordType!Employee.relationships.employeeLevel.fields.annualBonus,
        0
     )
   }
)

Feature compatibility

Feedback