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:


      Start DateTermination DateTerminated?


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