How to Create Formula
Creating New Formula
Navigate to Agreements & Promotions > Formulas to open the Formula Library.
Click the Create New Formula button.
Enter a label for the formula you want to create and specify access rights (optional).
Select the desired formula type from the Active Types drop-down menu. See the Creating a Formula Type section below if you want to create a formula type from scratch.
Click the Submit button to save the formula and start the approval workflow.
After the formula is approved, it can be used for the price calculation of an agreement.
Creating Formula Type
In the Formula Designer, click the Add > Add Type button to open the Edit Types dialog.
A draft “NewFormulaXX” is now created.
Optionally, you can import an existing Formula Type in the JSON format (Add > Import).Build the type using blocks by following instructions described in the Formula Designer for Technical Users article.
Once you have finished building and your formula type is valid (see the indicator next to the formula type’s title), activate the draft using the blue Activate button (top-right corner of the block editor).
Your formula type is now displayed among the Active types. If you want to apply the type to the formula, click the Use in Formula button.
You can delete the formula type draft by clicking the three dots menu in the top-right corner and selecting Delete.
Creating a New Version of Formula Type
Formula types in the Formula Designer can maintain multiple versions. This introduces a way to version formulas without altering historical behavior.
Prerequisites
Pricefx version 15.0 or later.
The Enable revisions option in Advanced Configuration Options (AP) is enabled.
The Create New Version button is only visible for active formula types. It allows you to create a new version of the selected formula type, or lookup.
When the new version is activated, the previous version will be marked as superseded.
Edit Types Dialog
Description of the functionalities available in Edit Types dialog.
Types Tab
In the left sidebar, you can see all available formula types divided into two sections:
Active section: Displays all the active formula types that can be used in the formula. To use an active formula type in the formula, click the Use in Formula button (top-right corner).
Formula Types in this section cannot be edited. To edit an active formula type, you can create a draft based on this type by selecting the desired active type and clicking the Duplicate as Draft button.Drafts section: Lists all draft formula types that can be edited and are yet to be activated. If you want to activate a draft formula type, it must be valid – see the indicator next to the type’s title in the type editor (right main area).
A Formula Type can be exported to JSON via 3-dots menu (top-right corner) > Export.
Data Lookups Tab
Contains lookups that can be used in the Formula Designer in the Types tab. For more details, see the Create Data Lookup section in the Formula Designer for Technical Users.
Deleting Formula Type
An admin user with the AGR_FormulaAdmin business role can delete existing formula types. For more details, see How To Delete Formula Types Using the Formula Management Wizard.