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?