Raul Munoz

IfElse Calculated Formula - Easy

Discussion created by Raul Munoz on Dec 30, 2017
Latest reply on Jan 2, 2018 by Nathaniel Ray

Hello, 

 

I'm new to SugarCRM and I'm trying to calculate an ifelse function. $skirting_c is a dropdown with "Yes" and a blank as the drop down values. If option "Yes" is selected, we want a "1" to be returned, if the blank value is selected we want the return to stay blank as well. I tried the following,

 

ifElse(equal($skirting_c,"Yes"),number(1),number(1)),

ifElse(equal($skirting_c,"blank"),number(""),number(""))

but keep getting the following syntax error:

"1)),ifElse(equal($skirting_c: Syntax Error, no close parentheses found".

Please help.

 

 

Outcomes