Solved

Merge MIn and Max of Opportunity with Opportunity data

  • 3 December 2021
  • 2 replies
  • 23 views

Userlevel 2
Badge +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!

icon

Best answer by abhijeetbakare 6 December 2021, 10:06

View original

2 replies

Userlevel 7
Badge +2

@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. 

Userlevel 2
Badge +1

used this solution to achieve what I wanted to.

 

 

Reply