[SalesForce] Unable to reference a formula field in roll up summary

I have a formula field Broker_value__c on opportunity product which is a currency field. I need a sum of this field for opportunities closed today in my opportunities.

I also created a formula field in opp products to see if the opportunity is closed today or not as a boolean and was trying to use this field in the roll up summary as filter criteria. But i am unable to get this formula field in the filter criteria of the roll up summary.

Any ideas on how we can get the sum of broker_value on opportunities for opps closed today?

Best Answer

It will only work if the formula field will refer fields of same object. You can find your solution to this at here : http://blog.wdcigroup.net/2012/07/salesforce-tips-roll-up-summary-with-formula-fields/

Related Topic