I am trying to get the Line closed Date on the saved search and when I use this formula it repeats the same line multiple times, I have mainline, Cogs line,ship line and Tax line as False in Criteria. what am I missing here. case when {linesystemnotes.field} = 'Closed' and {linesystemnotes.newvalue} = 'T' then {linesystemnotes.date} end

Maybe add another criterion for Line System Notes Fields... where Field = Close (or whatever it is called in the line system fields)?

no I want all lines on a PO for the month, but if the line is closed, I need the date it was closed