Price Lists - Discount calculations (Alternate Calculation method)

Price Lists - Alternate Discount calculation method needed. We need Price List Discount "Scaling/Tiered"?, not just straight Discount on total quantity. Sample current pricing structure. Base / Current Cost on Product is 0.3 cents Discount Levels created 1-500 = 0.3 cents 501-1000 = 0.25 cents (.05 Discount) 1001-2000 = 0.20 cents (.10 Discount) 2001 – 10000000 = .18 cents (.12 Discount) I created Discount Lists, but currently the “Total$” calculation is based on the total Qty * Discounted price. Sample, for Qty of 1500 of this Product, Doing a Quote in D365 calculates as 1500* (.3-.1) = $300 Our current accounting system does the math as below. Trying to mimic this in D365. All the calculation data in the defined discount lists, just need to do the math differently! This is the math we need! (500 *.3) + (500 * .25) + (500 * .20) = $375 Thanks for considering.