Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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...
Need Help
  • themistoklis's avatar
    themistoklis
    5 years ago

    Hello Anonymous 

     

    It should be like this:

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

themistoklis's avatar
themistoklis
Community Champion
5 years ago

Hello Anonymous 

 

It should be like this:

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