Error in formula

[Kuroshi]

Hi, I created this formula: 
CASE
WHEN [@authfield:field1] IS NULL
THEN 0
ELSE [@authfield:field1]
END

When I verify it, it says valid. But when I preview it, it says Error in formula.
 

[Barbie]

Hi Batchini, may you please try this Case when statement instead?

CASE
WHEN '[@authfield:BTN_User_Accounts_Permanent_Discount]'=''
THEN '0'
 
ELSE '[@authfield:BTN_User_Accounts_Permanent_Discount]'
 
END
 

I changed the IS NULL to ' '

 

hope it works on you.

-Barbie

[cheonsa]

For more reference, here's the link to the list of available formula: https://howto.caspio.com/function-reference/

[PotatoMato]

Hi, just to update this post. You may also check this how-to article regarding the causes of 'error in formula' message: https://howto.caspio.com/troubleshooting/errors-and-messages/

[Ulensr]

Hi 

you should also try to ensure that the type you are using in your calculation is consistent with what you wish to achieve.

In Barbie's reply you end up with 0 as a string. If that is what you need fine, if not, you can use the Cast or Convert function as in LittleMsGinger's link

You could try the following

CASE
WHEN '[@authfield:BTN_User_Accounts_Permanent_Discount]'=''
THEN Cast('0' AS int)
 
ELSE Cast('[@authfield:BTN_User_Accounts_Permanent_Discount]' AS int)
 
END