+ Start a Discussion
aknightaknight 

Product Formula

I need to write a formula that will enable me to add the list price items on the product section on the opportunities tab together and total them in a field below the amount field. This is so I can track how much discount our sales team have been giving from our list price to the customer. If this is possible pleae let me know how to perform this function.

Thanks

Andrew
KierenJamesonKierenJameson
So from this I'm gathering what you want is the list price x qty rolled up? Correct?

If so, then you will need to create a formula field on the opportunity product with the calculation and then create a rollup of it on the opportunity. 

Unfortunately Out-of-the-box you can't create a rollup on a formula field. but there is a free app called Rollup Helper that can do that for you:
https://appexchange.salesforce.com/listingDetail?listingId=a0N30000009i3UpEAI