How to apply automatic discount on the Unit List Price?

Summary:

I have a requirement to apply an automatic discount based on the selling price.

For Example:

Item_1: Unit Selling Price is 100 QAR

Condition:

If the unit selling price is greater than or equal to 100, then apply a 5% discount.

If the unit selling price is less than 100, then apply a 2% discount.

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):