Skip to main content
Topics#Data ManagementLori Rott's Question
Lori Rott (Omada Health) asked in #Data Management
Aug 29, 2019, 7:51 PM

The formula expression is invalid: Syntax error. Missing ')'

Gah, the dreaded missing ')' error! I cannot for the life of me figure it out. Below is my process builder formula...essentially, based on the quentity of a product, I want to fill in a date field. Quantity of 1, add a month, quantity of 2, add 2 months and so on.

 

CASE(

 

[OpportunityLineItem].Quantity,

 

1,ADDMONTHS([OpportunityLineItem].Opportunity.ia_crm__Start_Date__c,1)

 

2,ADDMONTHS([OpportunityLineItem].Opportunity.ia_crm__Start_Date__c,2),

 

3,ADDMONTHS([OpportunityLineItem].Opportunity.ia_crm__Start_Date__c,3),

 

4,ADDMONTHS([OpportunityLineItem].Opportunity.ia_crm__Start_Date__c,4),

 

5,ADDMONTHS([OpportunityLineItem].Opportunity.ia_crm__Start_Date__c,5),

 

6,ADDMONTHS([OpportunityLineItem].Opportunity.ia_crm__Start_Date__c,6),

 

7,ADDMONTHS([OpportunityLineItem].Opportunity.ia_crm__Start_Date__c,7),

 

8,ADDMONTHS([OpportunityLineItem].Opportunity.ia_crm__Start_Date__c,8),

 

9,ADDMONTHS([OpportunityLineItem].Opportunity.ia_crm__Start_Date__c,9),

 

10,ADDMONTHS([OpportunityLineItem].Opportunity.ia_crm__Start_Date__c,10),

 

11,ADDMONTHS([OpportunityLineItem].Opportunity.ia_crm__Start_Date__c,11),

 

12,ADDMONTHS([OpportunityLineItem].Opportunity.ia_crm__Start_Date__c,12),

 

[OpportunityLineItem].Opportunity.ia_crm__End_Date__c )
2 answers
  1. Jayson Morales (Accenture)
    Aug 29, 2019, 8:07 PM
    Hi Lori,

     

    You forgot "comma" after 1):

     

    Hi Lori, You forgot

     

    Try this:

     

     

    CASE(
    [OpportunityLineItem].Quantity,
    1,ADDMONTHS([OpportunityLineItem].Opportunity.ia_crm__Start_Date__c,1),
    2,ADDMONTHS([OpportunityLineItem].Opportunity.ia_crm__Start_Date__c,2),
    3,ADDMONTHS([OpportunityLineItem].Opportunity.ia_crm__Start_Date__c,3),
    4,ADDMONTHS([OpportunityLineItem].Opportunity.ia_crm__Start_Date__c,4),
    5,ADDMONTHS([OpportunityLineItem].Opportunity.ia_crm__Start_Date__c,5),
    6,ADDMONTHS([OpportunityLineItem].Opportunity.ia_crm__Start_Date__c,6),
    7,ADDMONTHS([OpportunityLineItem].Opportunity.ia_crm__Start_Date__c,7),
    8,ADDMONTHS([OpportunityLineItem].Opportunity.ia_crm__Start_Date__c,8),
    9,ADDMONTHS([OpportunityLineItem].Opportunity.ia_crm__Start_Date__c,9),
    10,ADDMONTHS([OpportunityLineItem].Opportunity.ia_crm__Start_Date__c,10),
    11,ADDMONTHS([OpportunityLineItem].Opportunity.ia_crm__Start_Date__c,11),
    12,ADDMONTHS([OpportunityLineItem].Opportunity.ia_crm__Start_Date__c,12),
    [OpportunityLineItem].Opportunity.ia_crm__End_Date__c )

     

    Hope that helps.

     

    Regards,

     

    Jayson

     

     
Write an answer...
0/9000