Hidden Saved Search Function

There is at least one saved search function that you won’t see in the dropdown list, NS_CONCAT. If you ever need to concatenate line items into one row for example this function may be helpful.

Using a formula of “NS_CONCAT({item})” set to a Summary of Maximum like shown above will reveal all of the items on that transaction in a single row which can be useful when you’re looking for a class of items that appear on multiple transactions, but don’t want to see repeating rows for every item.