Hi! I want a saved search that shows all sales orders, only the head, not the lines. And one column shall be ”contains item X” and ”Yes/No”on the head line of the so if it contains that item. Anyone? Main line false and group some way
e
eblackey
05/27/2023, 11:55 AM
What other columns are you wanting to display in the results? That will probably determine what’s possible within SavedSearch.
n
Nic Answer
05/28/2023, 1:45 PM
Could you do a search and then add a formula column to check the criteria for the item. Or case when {item} = ‘abc’ Then ‘1’ Else ‘0’ end and then sum that column and group others? Or something like that?