4 Replies Latest reply on Aug 6, 2016 6:42 PM by Simon Cecil

    Creating measures by performing calculations on a dates field

    Simon Cecil

      I'm working with a human resources data base. I want to create a field that returns a value of 1 if a person has a termination date, and a value of 0 if they have no termination date. I'm not clear on how to do this using an IF statement.

       

      The goal would be to have something like this:

       

      Name
      Start DateTermination DateTerminated?
      Abbie1/1/15null0
      Bill6/15/141/2/151
      Claire3/3/156/1/151

       

      I'm not sure how to write the equation that would return the values in the Terminated? column. Any help would be much appreciated.