IfElse (Calculated value in Formula Builder)

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:


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 Children
  • 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!


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