2 Replies Latest reply on Sep 28, 2018 2:24 PM by Katie Siedenstrang

    If Then Calulations Involving Multiple Fields

    Katie Siedenstrang

      I am trying to create a formula that will identify when any of three different fields are blank on an item.  The following formula produces a result but is not working the way I need.  Basically, I want the result to show that if any of the three fields have a blank entry, then consider it 'not tagged' (0), if all three fields have data then consider the the item 'tagged' (1).  I am fairly new to Tableau so I am sure this is a simple fix, but I can't seem to figure it out.  Can anyone help?

       

      if(isnull([Device Type])and isnull([Customer Application]) and isnull([TAMBA Name]))then 0

      else 1

      END