Skip to main content
Solved

Merge MIn and Max of Opportunity with Opportunity data


Forum|alt.badge.img+1

I am trying to archive this Opp end result in the data designer. If any one has done this before or can solve this would be helpful!

Best answer by abhijeetbakare

used this solution to achieve what I wanted to.

 

 

View original
Did you find this topic helpful?

2 replies

dan_ahrens
Forum|alt.badge.img+2
  • Expert ⭐️⭐️⭐️
  • 1984 replies
  • December 3, 2021

@abhijeetbakare - it looks like you want to determine the MIN and MAX values for a given cohort of records and then show those MIN and MAX values on all records in that cohort, is that correct? 

 

If so, this can be done using two fetches, as you’ve shown, and then using a MERGE that has a merge on a field that is common to all records, which will allow the data from the second fetch (with the MIN and MAX values) to be appended to all records from the first fetch. 


Forum|alt.badge.img+1
  • Author
  • Helper ⭐️
  • 11 replies
  • Answer
  • December 6, 2021

used this solution to achieve what I wanted to.

 

 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings