SSP need to calculated based on Discount % thresholds
SummarySSP need to calculated based on Discount % thresholds
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.