AnsweredAssumed Answered

Function working intermittently

Question asked by EP on Apr 21, 2014
Latest reply on Apr 21, 2014 by philmodjunk

Title

Function working intermittently

Post


     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?

     Thanks

      

Outcomes