Hi Adam,
What kind of database are you using ?
I believe that "IF(condition, value_if_true, value_if_false) " syntax is not a valid sql / oracle syntax unless you are using MySQL but currently OutSystems only supports Oracle / SQL Server databases.
Instead, use the CASE WHEN syntax. Please use this link as a reference