AnsweredAssumed Answered

Function working intermittently

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


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?