case when {systemnotes.newvalue} = 'Approved for Posting' then "Approved" else null end this is not working. this is for my saved search on result tab. can anyone help

@dane I would use Formula (Numeric) | Summary Type = Group | CASE WHEN {systemnotes.newvalue} = 'Approved for Posting' THEN 'Approved' ELSE END. Provided the Approved for Posting is the exact texts in system notes. You can't use double quotes in formula. I would not use 'END' in Results tab. Hope this helps!