function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
LDragoLDrago 

Salesforce quotes-autocalculate discount

I'm trying to have SF autocalculate the difference between the list and sales price in quotes and have it show as a discount percentage. Does anyone know which formula I would use and what steps to take? Your assistance is appreciated. Thank you!

Pradeep_NavatarPradeep_Navatar

Try out the formula given below :

IF( AND(  NOT(ISNULL( PricebookEntry.UnitPrice )) , NOT( ISNULL( UnitPrice ) ) ) , ABS(( PricebookEntry.UnitPrice  -  UnitPrice )) * 100/( UnitPrice  +  PricebookEntry.UnitPrice ) ,0 )
LDragoLDrago

Hi Pradeep thank you for the formula. SF is not allowing me to place into where quote line items are on a SF quote.