Trying to create a Transaction saved search to show the last time a transaction was modified prior to the transaction being approved. When the transaction gets approved, three fields get modified -- Impact, Document Status, and Posting Period -- so we ignore system notes entries for those fields. Here's our formula, but we get an 'unexpected error'. Any ideas?

CASE WHEN 
{systemnotes.field} != 'Impact' AND 
{systemnotes.field} != 'Document Status' AND 
{systemnotes.field} != 'Posting Period' 
THEN 
MAX({systemnotes.name})KEEP(DENSE_RANK LAST ORDER BY{systemnotes.date}) 
END

Try to add a space between MAX and (