Siebel Loyalty Administration Guide > Setting Up Siebel Loyalty Promotions > Formulas in Siebel Loyalty >

About the Formula Builder

The Formula Builder enables you to define complex formulas using all the attributes defined and visible at the Loyalty Program level in combination with the following operators:

• + Addition
• - Subtraction
• * Multiplication
• / Division
• ( Left Parenthesis
• ) Right Parenthesis

The formula builder is the main Formula definition screen that enables you to define the basic formula, associate it with the correct Loyalty Program and provide a description of how the formula is used. Selecting the Formula name on the Loyalty Promotions Administration - Promotion Formula screen takes you to the formula builder screen.

The Formula Builder has the following characteristics:

• You build the formula by adding rows in sequence to the formula builder. Some operators apply to objects and attributes, but others (such as the opening and closing parenthesis) do not.
• A formula row can include an Object and Attribute combination or a Literal and Value combination in addition to its operator. Depending on the choice, the necessary fields become conditionally mandatory and can be updated. For example, if you choose Literal in the Object field, then you must enter a number in the value field and the Attribute field is grayed out.
• A formula row can have an opening or closing parenthesis. Rows with a parenthesis cannot contain any other attribute or mathematical operator.
• The sequence number of the line automatically increments by one for each new line you add.
• The rows of the formula are sorted by sequence number in ascending order to generate the final formula. You can manually update the sequence number field to change the formula.