i have a customer saved search and I want to show data only when it has its first order against it. do I need a case statement or is there another way? I tried this without much luck: CASE WHEN COUNT({transaction.internalid}) == 1 THEN 1 ELSE 0 END - Your formula has an error in it.

You don't need a double

==

, that is probably the problem.

yeah, I think it should be a single =. it throws an unexpected error now - having looked in the Function download, it seems Count isn't listed so maybe that's the issue.