Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
VSK98VSK98 

The formula expression is invalid: Syntax error. Found ',' on PB

Hello All,

Getting the error "The formula expression is invalid: Syntax error. Found ','" on PB when i used the formula expression.

Snippet: 
IF([Object__c].amount__c <>  null, [Object__c].amount__c ,0)

Thanks,
VSK98​​​​​​​
AnudeepAnudeep (Salesforce Developers) 
Hi VSK98, 

IF([Object__c].amount__c <> NULL, [Object__c].amount__c ,0)

I have always seen null specified as 'NULL'. If this doesn't help, you can try ISBLANK([Object__c].amount__c)

Anudeep
MoonpieMoonpie
Hi VSK98,

I agree with Anudeep.

But if you MUST check for null explicitly, you can use ISNULL just like Anudeep showed ISBLANK: 
ISNULL([Object__c].amount__c)
Which would give you either... 
IF(ISNULL([Object__c].amount__c), 0, [Object__c].amount__c)
...or: 
IF(NOT(ISNULL([Object__c].amount__c)), [Object__c].amount__c, 0)
-----
But I think this one is the best: 
NULLVALUE([Object__c].amount__c, 0)

It is in the form of... 
NULLVALUE(expression, substitute_expression)
...so it does the logic for you if you want to keep the original expression as long as it is not null.
 
MoonpieMoonpie
Hi VSK98,

Did you try what any of us suggested?  If so, did it work?
Or did you do something else that worked?
Or do you still have the problem?

Please update.

Thanks!