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개
Eric Praud (Activ8 Solar Energies) Forum Ambassador
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)))