4 Replies Latest reply: May 23, 2018 10:46 AM by Jordy Wegman RSS

    If statement formula

    Aaron Dhobi

      Hi Guys.


      I need help with an if statement.


      I have two columns in a table.


      Column A and Column B


      I want to write statement to say


      When Column B is NULL to Column A then give the value Unknown


      So far i have only wrote an if statement for Column B but it is still not working


      if(len(trim(ColumnB)) = 0, 'Unknown', ColumnB) as ColumnB,