On each Account I have a discount rate which I am using on as a lookup on my quote details table.
Each line item I have on the quote has the discount percentage taken off but for some reason its taking 0.25 off the price per item when I want it to take 25% of the total off the item.
Here is my calculation for Total
PriceLookup * Amount - Discount
PriceLookup is the price of the product and Amount is the quantity wanted.
What would I need to change in the calculation so that it takes off the discount % off the item.