Custom Column with Or

[Anonymous]

Hi Experts

How would you write the following in M Script as a custom column

= if [type redemption = "Early" or "Full" then [Cash Amt] else Null 

getting an error on second condition "Full"

[themistoklis · Accepted solution]

Hello @Anonymous 

It should be like this:

if [type redemption] = "Early" or [type redemption]= "Full" then [Cash Amt] else null