Managing CPQ Formula Fields
You can create a CPQ formula field using a simple formula or using the Conga Numeric Expressions Framework, so that you can use the formula field for configuring prices and adjustments. You can create a formula on any numeric or currency type of custom field on the line item object and use that formula as a dimension while calculating adjustments. Instead of providing the adjustment amount as a static number, you can use a CPQ formula to make the adjustment amount as a variable that is evaluated in run-time. You can use the CPQ formula field while creating a price rule, price matrix, related pricing, and default pricing (as a list price).
For example, you can create a formula field on the Number of Beds field on the line item object as follow:
- Name of the formula field: Auto_Pricing_FormulaPricing_NumericField
- Business Object: Apttus_Config2__LineItem__c
- Field: Number_of_Beds__c
You can use this formula field Auto_Pricing_FormulaPricing_NumericField in the Adjustment Amount Source field while creating a price matrix. If the Sales Representative enters 10 in the Number of Beds field, the value of the formula field is 10. CPQ populates the same value of 10 in the Adjustment Source Amount field.
To use numeric expressions while creating CPQ formula fields, you must add the Picklist value Expression, to the Picklist field Use Type. Go to Setup > Create > Objects > Formula Field (CPQ) > Use Type field.
- On App Menu, click Conga CPQ Admin and then click the CPQ Admin tab. The new admin console is launched.
- On the Pricing menu, click Manage CPQ Formula Fields.
- Click New Formula Field. The DETAILS tab is displayed.
- Enter the following details and click Save.
- Name: Enter a name for the formula field.
- Business Object: Select a business object on which you want to create the formula field.
- Description: Enter a description for the formula field.
- Usage: Select the type of usage for the formula. Supported values are:
- Reference (default): If you select this option, the Formula field is displayed.
Expression: If you select this option, the Expression field is displayed.
- Formula: Enter a formula as a text.
- Expression: Click the expression lookup. The Edit Expression dialog box is displayed. Configure a formula using numeric expressions and click Ok. For more information, see Configuring Numeric Expressions.