You are here:
Apply Price Rounding Values
Precisely calculate the price of your product using Rounding Values in your pricing procedure to ensure accurate pricing amounts.
Required Editions
| Available in: Lightning Experience |
| Available in: Enterprise, Unlimited, and Developer Editions of Revenue Cloud where Salesforce Pricing is enabled |
Rounding ensures that financial calculations use the correct number of decimal places for the currency, rounding results up or down based on the applied rounding rule. The rounding rules applied are:
- Round Up: This rule rounds the currency value of an item to the nearest higher value. For example, if a pen costs US$1.60, applying this rule adjusts the price to $2.
- Round Down: This rule rounds the currency value of an item to the nearest lower value. For example, if a pen costs $1.60, applying this rule adjusts the price to $1.
- Half Up: This rule rounds the currency value of an item to the nearest number based on its decimal value. For example, if a pen costs $1.45 and you select the Half Up rule, the price adjusts to $1.50. However, if the pen costs $1.20, the price adjusts to $1.00.
For single-currency orgs, the Rounding Values element sets the rounding precision. However, if multicurrency is enabled, the Rounding Values element ignores the Precision input parameter and automatically applies the decimal places defined for each currency in your Manage Currencies settings. See Manage Multiple Currencies.
In addition to setting overall precision, the Rounding Values element also plays a crucial role in determining the final currency outputs from preceding pricing elements, such as Manual Discount and Volume Discount.
Use the Rounding Values Element
Use the Rounding Values element to ensure that the output of any pricing element in a pricing procedure is rounded to the specified decimal place.
Required Editions
| User Permissions Needed | |
|---|---|
| To create, update, and delete pricing procedures: | Salesforce Pricing Design Time User |
Let's consider a scenario where you want to set conditions to only give discounts when a customer purchases 50 or more printer bundles, and you're calculating the discounts using a formula. For this example, let's set ItemNetTotalPrice to be rounded down to the first decimal point.
Create a Constant for the Precision Variable
- Create a pricing procedure. To create a pricing procedure, follow the first 5 steps in Configure Your Pricing Procedure.
-
On the Pricing Procedure builder canvas, click
.
- On the Resource Manager panel, click Add Resource.
-
In the Add New Resource page, specify these details.
- Resource Type: Constant
- Resource Name: PrecisionVariable
- Data Type: Number
- Decimal Places: 2
- Default Value: 1. This value specifies that the product's price should be rounded to one decimal place.
- Save your changes.
Add the Rounding Values Element
-
Now, add the Pricing Setting element and map these variables.
- Input Variables
- Line Item: LineItem
- Output Variables
- Price Waterfall: price_water_fall
- Net Unit Price: NetUnitPrice.
- Subtotal: ItemNetTotalPrice
- Input Variables
-
Add the List Price element to fetch the base price of the product.
Under Lookup Table Details, select the Price Book Entries decision table and map these variables.
- Input Rule Variables
- Product: Product
- Price Book: PriceBooks
- Product Selling Model: ProductSellingModel
- Input Variables
- Quantity: LineItemQuantity
- Output Variables
- List Price: ListPrice
- Subtotal: ItemNetTotalPrice
- Input Rule Variables
- Add the List Group element.
-
In the list group, configure the List Operation by setting a condition that a 10% discount
on the final price of the printers can only be applied if the user purchased over 50 units.
- Filter Condition Requirements: All Conditions Are Met (AND)
- Resource: # LineItemQuantity
- Operator: Greater Than
- Value: 50
-
Within the list container, add the Formula Based Pricing element and specify these
variable values.
- Calculation Formula: ItemNetTotalPrice - ( ItemNetTotalPrice * 0.10 )
- Output Variable: TotalLineAmount
-
Outside the list container, add the Rounding Values element and specify these variables.
- Fixed Input Variables
- Precision: PrecisionVariable
- Rounding Rules and Variables
- Input Variable: ItemNetTotalPrice
- Rounding Rule: Round Down.
- Output Variable: ItemNetTotalPrice
- Fixed Input Variables
-
Click
and select Include in Output.
- Finally, set your preferences to view pricing information, profile access, and rank information.
- Save your procedure.
-
Click Simulate to test your procedure. Enter the input values for
your printer bundle product and click Simulate again.
The price waterfall shows the formula used to calculate the total cost of the printer bundles with a discount of 10%. You can also see that the rounded price has been applied to the Net Amount to the first decimal.
