I'm trying to restrict Users from adding a Sales Price that has a discount of more than a 5% (Without getting into too much detail, restricting the Discount field and changing settings to prevent users from changing the Sales Price is not an option).
Example:
If the List Price for Product A = $10,000
The Sales Price can't be less than $9,500
I added the following Validation Rule on the Opportunity Products:
( ListPrice - ( ListPrice * 0.05)) <= UnitPrice
But with this I only got an error if the Sales Price is equal to our greater than the List Price. I tried changing it to:
( ListPrice - ( ListPrice * 0.05)) >= UnitPrice
but nothing happened.
Can someone let me know what I might be doing wrong :/
Thanks,
Boshra
1 answer
HI Boshra,
Give a try below
(ListPrice - UnitPrice)/ ListPrice > 0.05
