Skip to main content
Hi All,

 

I have created a Formula in Process builder for which I'm getting the error: Error: The formula expression is invalid: Syntax error. Missing ')'. I have been trying to get this right unfortunately I'm not able to figure out.

 

Any help here would be much appriciated, Thanks in advance.

 

Logic:

 

Discount cert =

 

If the [Opportunity].SQ_Footage__c <= 300, then 0.

 

If the [Opportunity].SQ_Footage__c >= 1000, then 700.

 

If the [Opportunity].SQ_Footage__c is > 300 and < than 1000, then ([Opportunity].SQ_Footage__c - 300)

 

Formula:

 

I have used CASE as it need to be assigned to diffrent Record Type , which in my case in 

 

RecordType.Name, "New Development"

 

RecordType.Name, "Occupied"

 

CASE([Opportunity].RecordType.Name,

 

"New Development", 

 

if

 

(AND([Opportunity].SQ_Footage__c>300,[Opportunity].SQ_Footage__c<1000),([Opportunity].SQ_Footage__c - 300),

 

if

 

([Opportunity].SQ_Footage__c<=300,0, 

 

if

 

([Opportunity].SQ_Footage__c>=1000,700, [Opportunity].SQ_Footage__c)),

 

"Occupied",

 

if

 

(AND([Opportunity].SQ_Footage__c>300,[Opportunity].SQ_Footage__c<1000),([Opportunity].SQ_Footage__c - 300),

 

if

 

([Opportunity].SQ_Footage__c<=300,0, 

 

if

 

([Opportunity].SQ_Footage__c>=1000,700, [Opportunity].SQ_Footage__c)),0)
11 respuestas
  1. Eric Praud (Activ8 Solar Energies) Forum Ambassador
    10 dic 2020, 12:42 p.m.
    Hi,

     

    You could try this:

    IF(CASE([Opportunity].RecordType.Name,"New Development", 1,"Occupied",1,0)=0, NULL,

    IF([Opportunity].SQ_Footage__c<=300,0,

    IF([Opportunity].SQ_Footage__c>=1000,700,[Opportunity].SQ_Footage__c - 300)))