3 Replies Latest reply on Nov 27, 2018 12:47 PM by Jeff Strauss

    Calculating Lifespan

    Zora Gruber

      I would like make a calculated field with the liefspan of people. So far I have only two dimensions in colums: birthyear and to. But sometimes in the "to" colum, there is a "0", because the person is still alive.

      What abou this idea?

      IF [To] = "0" THEN 2018 ELSE [To] - [Birthyear] END

       

      I'm looking foreward to your answer.