Hi everyone, the scenario is that I've created a saved search on bin transfer transactions. The behavior is such that it returns three lines: the main line (Header), the From bin line, and the To bin line.
I want to know if there's a way to filter out the 'From Bin' row or the 'To Bin' row." Any help would be greatly appreciated.
c
Castor
04/17/2024, 7:33 PM
Send a screenshot of criteria and results please
v
Vaibhav Patil
04/18/2024, 6:09 AM
c
Castor
04/18/2024, 3:13 PM
Try maximum of 'from' and 'to'
v
Vaibhav Patil
04/19/2024, 2:43 PM
I have taken two to three additional examples to better understand our situation. As you can see, I have used 'maximum' as the summary type for both formula fields, but it's not producing the expected result.
I have shared screenshots showing the before and after states.
c
Castor
04/19/2024, 2:56 PM
@Vaibhav Patil i sent you a help article in DM.
v
Vaibhav Patil
04/22/2024, 12:35 PM
Thanks, @Castor Your solution worked like a charm. I really appreciate it.