Formula to subtract discount percentage from List Price
I first tried this:
ListPrice - Discount
But for some reason, it doesn't seem to recognize the Discount field as a percent. So then I tried this:
(ListPrice) - (Discount / 100 * ListPrice)
But that didn't work either. The math seems to be right but maybe my syntax is wrong? Any suggestions
Your formula should be something like this:
(ListPrice - (Discount * ListPrice))
It doesn't in ours. Even if we fill in the discount field, the sales price stays the same as the list price. Am I missing something?
When I activate the workflow rule, the sales price is correct, but then the total is off. It looks like the discount is being applied twice:
Here is a screenshot of the workflow rule:
the standard SFDC Opportunity Product.Discount% is automatically applied to the Sales Price to calculate the Total Price for the Line Item. By applying the Discount% to the List Price you're deducting it twice.
Any insight you can offer would be greatly appreciated.
Here is how Total Price is calculated: https://help.salesforce.com/articleView?id=000003106&type=1
If users are editing Sales Price and Discount, then a double discount will be applied to Total Price.