Conga Product Documentation

Welcome to the new doc site. Some of your old bookmarks will no longer work. Please use the search bar to find your desired topic.

Rated Amount Calculation Using Tier-Level Discounts and Markups

The rating engine computes the final per-unit price by applying tier-level percentage adjustments (discounts or markups) to the Net Unit Price available onthe billing header, rather than tier level unit price. This ensures that unit price is the same but it can get discounted/marked up based on the consumption.

Required Inputs and Computation Logic

The rating engine requires inputs such as Net Unit Price, Adjustment Type, Adjustment Amount, and Quantity to execute this functionality. The following table lists the source from where these inputs are fetched.
InputSource
Net Unit PriceBilling Header (derived from OLI/ALI after automated/manual discounts, promotions, and rebates)
Adjustment TypePrice Tier on the Order/Asset Line Item (% Discount or % Markup)
Adjustment AmountPrice Tier on the Order/Asset Line Item (percentage value)
QuantityUsage Input
The rating engine uses the following computational logic to calculate the rated amount when the price is per unit, and not a flat price:
  • For % Markup — Rated Amount = Quantity × (1 + Adjustment Amount / 100) × Net Unit Price.
  • For % Discount — Rated Amount = Quantity × (1 − Adjustment Amount / 100) × Net Unit Price.
Note: The calculated rated amount adheres to the currency decimal precision configured in Billing Settings.

After rating, the calculated amounts are rolled up from the usage inputs to the billing schedule record (BSR). The total rated amount across all rated usage inputs is populated in the Actual Fee Amount field, while the cumulative quantity from all usage inputs is displayed in the Total Usage Quantity field.

The total of all such Actual Fee Amounts is rolled up to the TCV (Usage) field on the respective billing header. The Total Bill Including Adjustments field displays the combined value of the TCV (Usage) amount and any applicable adjustments.
Note: TCV (Sales) on the billing header remains unchanged — it reflects the original value from the OLI/ALI. It does not capture the actual financial revenue from the consumption and its rating.

Dimension Values and Tier Matching

The tier-matching behavior varies depending on the dimension value type (Discrete, Range, or Cumulative Range) configured on the subscription. For more information on dimension values and tier matching, refer to Use Case: Consumption Based Billing Workflow.

Example

A billing header has a Net Unit Price of GBP 100.00 with currency decimal places set to 2 in the billing settings. The tiers are configured as shown in table.

Sequence (Tier) From/Tier Start Value To/Tier End Value Adjustment Type Adjustment Amount
1 1 100 % Markup 5.00
2 101 500 % Discount 5.00
3 501 2000 % Discount 10.00

For a Range as dimension value with a usage quantity of 550 (falls in Tier 3), the rated amount is calculated using the above computational logic as:

Rated Amount = 550 × (1 − 0.10) × 100 = GBP 49,500.00

For Cumulative Range as dimension value with the same usage quantity, the rated amount is:

Rated Amount = 100 x (1.05 x 100) + 400 x (0.95 x 100) + 50 x (0.9 x 100) = GBP 53,000.00

The above calculation demonstrates that the rating application applies tier-level percentage adjustments (discount in this case) to the Net Unit Price on the billing header to determine the rated amount.