Details about this thread
  • State Suggested Answer
  • Replies 4 replies
  • Answers 1 answer
  • Subscribers 86 subscribers
  • Views 6603 views
  • Users 0 members are here

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