# How Can One "Round Down" the Calculated Discount Amount by Capturing the SubTotal at the End of Pricing Bucket10 in a Custom Pricing Attribute That Can Then Be Rounded As Such n a Formula? (Doc ID 2401968.1)

Last updated on DECEMBER 05, 2019

## Applies to:

Oracle Advanced Pricing - Version 11.5.10 and later
Information in this document applies to any platform.

## Goal

How we can always round down the calculated discount amount by capturing the sub total at the end of pricing bucket10 in a custom pricing attribute that can be rounded as such in a formula?

Using the current functionality, we are not able to achieve the desired result. As an example consider the following scenario:

List Price: 1625
Discount: Promo PA : 350 : Amount Based Discount. - Pricing Bucket 10

Net Price after Bucket 10: 1625-350: 1275

Discount: Draft : 1% - Pricing Bucket 20

i.e. : 1275 *0.01 = 12.75 ---> This should be rounded DOWN to 12.00

Net Price after Bucket20 is 1275 - 12 : 1263

Discount: Brand Discount: 14% -- Pricing Bucket 30
Discount: Truck Allowance : 3% -- Pricing Bucket 30
i.e : 1263 * 0.14 = 176.82 ---> This should be rounded DOWN to 176.00
i.e : 1263 * 0.03 = 37.89 ---> This should be rounded DOWN to 37.00

Net Price after Bucket30 is 1263 - 176 - 37 = 1050.00

So the final unit selling price is 1050.00