+ Start a Discussion

Margin Forumla Problem -- different areas

I'm having a problem with my margin formula.  I've added a custom product field and entered cost information for all of my products.

I would like to track margin on my Opportunities based off this information.  However, since the cost information is in the product section, and the actual sales price for any given opportunity is in the Opportunity Products section, I can't write a formula that uses fields from two different sections.

However, it seems to me that cost information should exist with the price book/product.

How are others getting around this problem?