I have a saved search with a criteria set to 2 types - Invoice and Sales Order. I want a results column that gives me the count of only salesorder. I tried this formula with a Summary Type set to Sum but it is giving me 0 which I know is not correct:

CASE WHEN {type} = 'SalesOrd' THEN 1 ELSE 0 END

What is the correct formula to use?

Try {type} = 'Sales Order', I think in suiteql it's 'salesord' and in saved searches it's 'Sales Order'. You can also just group {type} and nothing else to figure it out too.