Calculated fields not working with formula script

[Juantreses]

Hi all,

I'm running into an issue where my calculated fields remain empty, even though I've defined a formula for them. Here's the context:

• EspoCRM version: 9.1.8
• Custom entity: BodyScan spierpercentage is a readonly field that should be filled with a formula
  
• formula:
  
  
  Despite this both vetmassa and spierpercentage fields remain null. I have verified the field names match. I've tried manually saving in the UI, clearing cache and running rebuild, checked logs: no errors to be found.
  
  Is there any issue in the way I've set this up? This is how I understood it from the docs. Any help is appreciated. Thanks!

[yuri]

Hi,

There's no 'IF' function. You need to use 'ifThenElse' instead.

https://docs.espocrm.com/administration/formula/general/#ifthenelse

[Juantreses]

Ok, thanks the calculated field is now saving correctly. I also found the error in the logs. The syntax check however told me everything was in order.