Function working intermittently
I have a solution that uses the following expression to determine if an "order" should be labeled as "new" to identify a first time orderer/customer:
If ( Clients::_pkClientID > 244 and Clients::OrderCount = 1; "NEW"; "")
This is used with a SetField function with NewOrder field after a user enter the order. It usually works but sometimes the NewOrder field isn't marked as "New." The reason for Clients::_pkClientID > 244 is bc 244 clients were initially imported into the system, so we only want this to evaluate on clients with an ID above 244.
Anything wrong with my expression?