Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

undefined

I have a three column i want a result like it select" T " from col1- and that should not contain 0 and null from col2 and col3  col1    col2   col3            A         1        null  A         2 ...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
4 years ago

Anonymous Maybe:

col4 = 
  SWITCH(TRUE(),
    [col1] = "T" && [col2] > 0 && [col3] > 0, TRUE(),
    FALSE()
  )