Formula Designer

Formula Designer enables you to create net price formulas within the Formula Library through a visual configuration, reducing the need to involve the configuration team.

Formula consists of Formula Type, definitions (input values provided for the price calculation), and attributes (e.g., region, business unit).
Formula Type is a reusable blueprint of the formula that you can create using the Formula Designer.

Formula Designer Layout

Open

Formula Designer consists of the following components:

Header

• Formula Title: The label of the formula being edited. You can change the label by clicking the “pencil“ icon.

• Status: Indicates the current status of the formula (e.g., Draft).

Action Buttons

• Submit: Saves the formula being edited and submits the Formula Type to the approval workflow .

• Duplicate: Creates a copy of the formula.

Tabs

• Types

  • Active Types button: Select a formula type from the drop-down menu that will be used in the formula.

  • Add Type button: Opens Edit Types dialog and creates a new blank draft so you can create a new formula type.

  • Edit Types button: Opens Edit Types dialog where you can select the formula type you want to use from existing active types, activate the draft formula type, or edit the active formula type (after duplicating as draft).

  • Formula Type preview area: Displays the preview of the selected formula type.

• Details
  Allows users to specify the input definitions, and attributes of a formula.

  • Definitions: If there are inputs that should be defined within the formula (this is defined in the active formula type), specify the input values that will be used in price calculation.

  • Attributes: Help you with categorizing and managing your formulas within the formula library. You can enter a longer description in the Formula Description field, for example, describing what this formula does. Fields in this section are also available as columns in the Formulas table (Agreements & Promotions > Formulas).

  • Recalculate button: Triggers a recalculation based on the defined input values and formula logic.

• Workflow
  In this tab, you can find a detailed information about the approval workflow process.