set a column to Null based on a condition with DSS Formula

moufkir
moufkir Registered Posts: 7 ✭✭✭✭

I have a column that I want to set to Null based on condition on another column value.

I succeeded to build the formula but did not find the keyword for Null

if(and(isNotNull(myColumn) ,myOtherColumn!= 'VALUE'), NULL, myColumn)

For the moment I put '' instead, but this is not what I want.

Thank you for your answer,

Mohammed

Best Answer

Answers

Setup Info
    Tags
      Help me…