Forum Discussion
Custom Column with Or
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"
Hello Anonymous
It should be like this:
if [type redemption] = "Early" or [type redemption]= "Full" then [Cash Amt] else null
1 Reply
Hello Anonymous
It should be like this:
if [type redemption] = "Early" or [type redemption]= "Full" then [Cash Amt] else null