Duplicate Opportunities, trying to get the date with the max value
I've created a rule where i want to find the max value in an opportunity and use the date on that opportunity to update the Customer object Renewal date. However, on some accounts there are two opportunities that fit my filter criteria. I'm putting in the Showing Area - the Max value for the Opportunity and the Close Date. However, when i pull in the close date, it always uses the most recent close date when i go to assign the customer info objects vs. using the close date on the opportunity with the Max value. How can i get the Close date from the opportunity that has the max value if there is more than 1 opportunity that pulls in for my criteria?
Already have an account? Login
Login to the community
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
I am the new Community Manager here at Gainsight and I am going through and checking to see if you were able to get this resolved or if it was an ongoing issue?
I get this to pull:
MAX:Total_Opportunity_Value__c CloseDate Average_MRR__c
12829.65 10/5/2015 0:00 1069.13
2200 11/25/2015 0:00 183.33
and the one that assigns is the 11/25/2015....
Let me know if this trick works.