SSP need to calculated based on Discount % thresholds

Summary

SSP need to calculated based on Discount % thresholds

Content

Hi Experts,

Here I have one scenario to fit into the system,

For Example the list price is $160 and the Sale Price is $90, So the Discount is $70,

if we calculate Discount amount into % we can get as 43.8%.

Our requirement is to check the Discount% with the range (fall-in the range between) 4% to 36% (I am not sure how to define this thresholds), then list price would become as sale price, else (if it is not in above range) we have a fixed % specified in some where table like below. 

 

attached the screen shot for the table and the determined value.