a!customFieldSubtract_26r9 Function

Function

a!customFieldSubtract_26r9( value1, value2 )

Used to create a real-time custom record field, this function returns the difference between two numbers. You can subtract 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!customFieldSubtract_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!customFieldSubtract_26r9() function in conjunction with other Custom Field functions, like a!customFieldSum(), 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 net salary.

The Employee record type has a grossSalary field, which contains each employee's salary amount. The Benefits record type has a deductions field, which determines the deduction amount based on the selected benefits plan.

To calculate each employee's net salary, you could create a custom record field on the Employee record type that evaluates in real-time so you can reference the related record field from the Benefits record type in your calculation.

The expression would look something like this:

1
2
3
4
a!customFieldSubtract_26r9( 
  value1: recordType!Employee.fields.grossSalary,
  value2: recordType!Employee.relationships.benefits.fields.deductions
)

Feature compatibility

Feedback