**Problem solved**
Hi all,
Caspio Newbie - looking to understand how to create a typical "If ... then .. " statement for a calculated field in a table.
On a different thread I read about creating a case and tried the following:
CASE
WHEN [@field:Loss_Amount] >= 1 THEN ‘Serious’
ELSE ‘Check’
END
but received the error
"Invalid formula: Incorrect syntax near '‘'.
Any suggestions on where I am going wrong?