Skip to main content
Topics#Data ManagementDomanda di Danielle Harrison
Danielle Harrison (AllCloud) ha fatto una domanda in #Data Management
18 dic 2018, 16:25

Hello, I am trying to create a validation rule on a picklist field and receiving the Error: Syntax error. Missing ') message.

Hello, I am trying to create a validation rule on a picklist field and receiving the  Error: Syntax error. Missing ')  message. My formula is:

 

IF ( INCLUDES ( parent.multipicklist__c , "EZ Pay"), EZ_Pay_Payments__c = 0 OR EZPay_Start_Date__c == null OR EZ_Pay_Down_Payment__c = 0 ELSE IF (EZ_Pay_Down_Payment__c >= Min_EZ_Pay_Down_Payment__c) AND (EZ_Pay_Payments__c <= Max_EZ_Pay_Payments__c)
6 risposte
  1. Edward Scott (Measured Results Marketing)
    18 dic 2018, 17:24
    Hi Danielle I think you are missing a ) at the very end. I wish we could use colors on here but let's try this. 

     

    IF *( INCLUDES $( parent.multipicklist__c , "EZ Pay")$, EZ_Pay_Payments__c = 0 OR EZPay_Start_Date__c == null OR EZ_Pay_Down_Payment__c = 0 ELSE IF &(EZ_Pay_Down_Payment__c >= Min_EZ_Pay_Down_Payment__c) &AND #(EZ_Pay_Payments__c <= Max_EZ_Pay_Payments__c)# 

     

    The open and close symbols match for everything except the *. So I think you just need one at the end.
Scrivi una risposta...
0/9000