Suggested Price from a Target Discount Rate

Purpose

This measure is used when a target discount rate has been defined, either based on a reference price or derived from comparisons with similar products or customers. It provides a suggested price that aligns more closely with the target discount, helping guide users toward consistent and compliant pricing decisions.

Business Context

In pricing scenarios where discounts vary across customers or transactions, directly enforcing a target discount may not always be practical. This measure recalculates the price that would correspond to the target discount rate while taking the current discount into account, enabling smoother alignment with pricing guidelines.

Definition

:question_mark:

The measure calculates a suggested price by adjusting the current price to reflect the target discount rate, relative to the current discount rate.

Business Formula

Suggested Price = Current Price × (1 − Target Discount Rate) / (1 − Current Discount Rate)

Agent Expression

CurrentPrice * (1 - TargetDiscountRate) / NULLIF(1 - CurrentDiscountRate, 0)