2 Replies Latest reply on Jul 22, 2015 12:36 PM by Gene Denny

    Calculated field where 2 conditions must be true.

    Gene Denny

      I can't seem to find the correct syntax for this for Tableau.  Maybe one of you can help.

       

      Given two fields, resolutionID (which is a number) and date, I want to create a calculated field that says--

       

      If date>7/1/2014 AND resolutionID IS NULL then 1

      else 0.

       

      Where am I going wrong?