IfElse (Calculated value in Formula Builder)

before diving into specifics...
as I remember there should be 2 parameters to compare for equal() 
e.g. could it be that equal($expensetype_c),"AnnualTerm" should be like equal($expensetype_c,"AnnualTerm") ?

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

not sure that I understood all the requirements, but the formula may look like this

ifElse(equal($expensetype_c,"AnnualTerm"),$annualmonth_c,
ifElse(equal($expensetype_c,"AdjustedTerm"),$adjustednumberofmonths_c,0))

I preconfigured your example here https://sg-example01.demo.sugarcrm.eu/ (login admin, password asdf) for the Notes module
You are welcome to login and try to create new Note to check the behavior, then check fields specifications in Studio

Let me know if that helps or any questions remain

not sure that I understood all the requirements, but the formula may look like this

ifElse(equal($expensetype_c,"AnnualTerm"),$annualmonth_c,
ifElse(equal($expensetype_c,"AdjustedTerm"),$adjustednumberofmonths_c,0))

I preconfigured your example here https://sg-example01.demo.sugarcrm.eu/ (login admin, password asdf) for the Notes module
You are welcome to login and try to create new Note to check the behavior, then check fields specifications in Studio

Let me know if that helps or any questions remain

Hi Dmytro

Thanks so much that has worked perfect now!... Appreciate your help, time and effort! Hopefully I'll be able to contribute to the group some day!!

Thanks again!

Sean