Discount Level Restriction on certain product code

Question

Hello, I want to restrict users from being able to apply more than 30% discount on a certain product.

My plan was to use the opportunity products object and use a validation rule.

I have created the below formula but it does not work.

AND(

Product2.ProductCode = "C-LFP-01"

Discount >"30" )

Am I approaching this correctly?

Many thanks for the help

Sunil Sarilla · Accepted Answer

Hi Jonathan,

The formula will be simply

AND(
 Product2.ProductCode = "C-LFP-01",
 Discount > 0.3
)

You do not need double quotes around the discount value, double quotes are for text fields not for number, percent or currency fields.

when using percent fields, 30% is 0.3, you should be using that.

Jonathan White · Answer

Update formula to:   AND(    Product2.ProductCode = "C-LFP-01",    Discount >30 )   But does not work

Data Management