Skip to main content
Topics#Data ManagementQuestion de Shilo Jackson
Shilo Jackson (Regence Blue Cross) a posé une question dans #Data Management
11 mars 2020, 19:50

syntax error

I'm trying to create a validation rule that a text field is required when a certain picklist option is selected. I'm getting this: Error: Syntax error. Missing ')' for the following VR formula:

 

AND ( 

 

ISPICKVAL(Premium_Holiday_Equal_To__c, 'Flat Dollar Amount'),

 

ISBLANK (TEXT (Amount_of_Premium_Holiday__c))

 

AND(

 

ISPICKVAL(Premium_Holiday_Equal_To__c, 1st Months Bill'),

 

ISPICKVAL(Premium_Holiday_Equal_To__c, '1st Months Bill Pro-Rated'),

 

ISPICKVAL(Premium_Holiday_Equal_To__c,  12th Months Bill'),

 

ISPICKVAL(Premium_Holiday_Equal_To__c, '13th Months Bill'),

 

NOT(ISBLANK (TEXT (Amount_of_Premium_Holiday__c)))

 

))
4 réponses
  1. Ahilesh Ragavan Radhakrishnan (Simplus)
    11 mars 2020, 20:33
    Yes, that's right you need 2 rules.

     

    Rule 1:

    AND( 
    ISPICKVAL(Premium_Holiday_Equal_To__c, 'Flat Dollar Amount'),
    ISBLANK(Amount_of_Premium_Holiday__c)
    )

     

    Rule 2:

    AND( 
    NOT(ISPICKVAL(Premium_Holiday_Equal_To__c, 'Flat Dollar Amount')), NOT(ISBLANK(Amount_of_Premium_Holiday__c))
    )

     

     
Rédiger une réponse...
0/9000