Formula error

[Altair]

I have something slight wrong with the formula

Formula:
WHERE ([@field:Member_status] ='Hibernated 2018/19') THEN 'N/A' ELSE 

SELECT ([@field:Sub_status_summary]) FROM m_membership_master_accounts WHERE Account_Email= target.[@field:Account_Email]

Error: Incorrect syntax near (.

[Nuke354]

For you to resolve the error message, please try this formula instead:

CASE
WHEN ([@field:Member_status] ='Hibernated 2018/19')
THEN 'N/A'
ELSE (SELECT ([@field:Sub_status_summary]) FROM m_membership_master_accounts WHERE Account_Email=target.[@field:Account_Email])
END 

Hope this helps.

[Barbie]

Hi,

Just to add some information, you can also check this link: https://howto.caspio.com/function-reference/ Just go to the "MISCELLANEOUS FUNCTIONS AND EXPRESSIONS" and you will see a sample syntax of case when function.

Hope this helps.

- Barbie