a!customFieldDivide_26r9 Function

Function

a!customFieldDivide_26r9( numerator, denominator )

Used to create a real-time custom record field, this function returns the results of dividing two numbers. You can use record fields, related record fields, or literal values of type Number (Integer) or Number (Decimal Floating) in your calculation.

Parameters

Usage considerations

Where to use this function

The a!customFieldDivide_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!customFieldDivide_26r9() function in conjunction with other Custom Field functions, like a!customFieldSubtract(), a!customFieldSum(), or a!customFieldMultiply() to create the calculations you need.

See the example below to see how you can use the a!customFieldDivide_26r9() and a!customFieldSum() functions together.

Example

Let's say you want to calculate the percent of projected revenue to total revenue. The formula to calculate the percent of projected revenue to total revenue is % Projected Revenue to Total Revenue = Projected Revenue / (Current Revenue + Projected Revenue).

The Customer record type has a currentRevenue field, which displays the current revenue generated by each customer. The Account record type has a projectedRevenue field, which displays the forecasted revenue for each customer account according to the sales department.

To calculate the percent of projected revenue to total revenue, you could create a new custom record field on the Customer record type that evaluates in real-time so you can reference the related record field from the Account record type in your calculation.

The expression would look something like this:

1
2
3
4
5
6
7
8
9
a!customFieldDivide_26r9(
  numerator: recordType!Customer.relationships.account.fields.projectedRevenue,
  denominator:  a!customFieldSum(
    value: {
        recordType!Customer.fields.currentRevenue,
        recordType!Customer.relationships.account.fields.projectedRevenue
    }
  )
)

Feature compatibility

Feedback