Last updated
Was this helpful?
Last updated
Was this helpful?
TDO can also perform mathematical calculations as part of a data assignment rule.
In the example below, we are calculating a fee based on a payment amount.
The calculation for the rule is 'payment amount x fee percentage' and the output is rounded to 2 digits. This rule is created by creating a rule container for the 'fee' field, and then opening the 'Compose' window for that rule. First, the payment amount is assigned to the rule. Then the Operator of 'Multiply' is selected, and the field 'fee' from the 'fee_view' is selected. This is then added (click the plus sign) to the Operands list.
Finally, the Operator 'Round' is selected, an a value of '2' assigned. ('Round' will round the amount to the right of the decimal point to the number of digits specified.) The full rule is shown below.
When assembled, the data output is shown below.
