Details about this thread
  • State Suggested Answer
  • Replies 4 replies
  • Answers 1 answer
  • Subscribers 87 subscribers
  • Views 4926 views
  • Users 0 members are here
Related content from around SugarClub

IfElse (Calculated value in Formula Builder)

Sean Mulligan

Hi. Very new to formula builder and calculations. Any help would be great, can't seem to figure where I'm going wrong.

$expensetype_c - Dropdown (AnnualTerm/AdjustedTerm)
If AnnualTerem ($annualmonths_c) Integer field, prepopulated with 12, readonly
If AdjustedTerm ($adjustednumberofmonths_c) Open to any numeric value 1 to 11

NumberOfMonths =
- If AnnualTerm then use the value of AnnualTerm ($annualmonths_c)
- ElseIf AdjustedTerm then use the value of AdjustedTerm ($adjustednumberofmonths_c).

Version 1:

ifElse(equal($expensetype_c),"AnnualTerm"),$numbermonthslraunvouched_c,$annualmonths_c),
ifElse(equal($expensetype_c),"AdjustedTerm"),$numbermonthslraunvouched_c,$adjustednumberofmonths_c))

Error:- ifElse: Syntax Error (Improperly Terminated String ')')34 35


I will have many fields reading the same Expesnse Type Dropdown so would like to either use either of the values based on Expense Type so this would be a massive help if solved!!.

Thanks a mil, Sean

Parents Reply
  • 0 in reply to Dmytro Chupylka

    Appreciate the reply and Info Dmytro!.. l wouldn't have picked up on that!  Possibly helped that error but getting another! 

    No worries if error not visible to you!

    ifElse(equal($expensetype_c,"AnnualTerm"),$numbermonthslraunvouched_c,$annualmonths_c),
    ifElse(equal($expensetype_c,"AdjustedTerm"),$numbermonthslraunvouched_c,$adjustednumberofmonths_c))

    Error - equal($expensetype_c,"AdjustedTerm": Syntax Error, no close parentheses found

    Regards

    Sean

Children