syntax error

Question

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)))

))

Ahilesh Ragavan Radhakrishnan · Accepted Answer

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))
)

Shilo Jackson · Answer

Thanks! That worked like a charm!

syntax error

Data Management

Aprendizaje relacionado

Más ayuda