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?