A calculated attribute is a read-only field whose value is calculated based on a specified formula.
When you save a form that contains calculated attributes, Unica Marketing Operations checks the formulas to ensure they are valid.
A calculated attribute has the following additional basic options.
You can perform the following binary operations.
You can perform the following operations on an arbitrary number of comma-separated operands.
Sum: for example, Sum(Salary, 1000, Bonus)
Avg: arithmetic average, for example, Avg(BudgQtr1, BudgQtr2, BudgQtr3)
Min: select the minimum value, for example Min(IQ, 125)
Max: select the maximum value, for example Max(Sale1, Sale2, Sale3, Sale4)An operand can be any of the following.
Assume the Wages form contains the following currency fields: BaseSalary, Bonus, Insurance, and FedTax. You could create a new calculated field named Net pay, and enter the following formula: BaseSalary+Bonus-FedTax-Insurance
Salary: an integer or money attribute
Commission = Salary + (Bonus * 0.10)
Bonus = (Commission * 0.5) + 1000The Commission and Bonus attributes refer to each other, creating an infinite loop when the system attempts to calculate the values.
Marketing Operations
8.5.0
|
Copyright IBM Corporation 2011. All Rights Reserved.
|
For more information, see our support and community site: Customer Central
|
|