@michoel I’m trying to create a Saved Transaction Search that combines a few summary columns together. One of the columns includes the User Notes field. We want to include the most resent User Note of a specific type. The issue is that transactions with multiple User Notes create “duplicate” line items that are submitted to the summarization functions. This can create incorrect tallies for some

SUM

and

COUNT

functions. I’ve sort of conceptualized a way to work around this but I would need to “loop” through the results returned by

DISTINCT

in order to remove a prefix that I would add in order to identify the unique line.