2 Replies Latest reply on Apr 11, 2013 2:21 PM by Chris Hubbuch

    Age formula

    Chris Hubbuch

      I'm trying to plot the ages of local officials over time. I set up a simple formula ([Year]-[Birth year]) that works fine, except in cases where the same person serves in more than one position (ie, city council and county board), in which case the age is doubled.

       

      Can anyone suggest a better formula?

      http://public.tableausoftware.com/static/images/Bo/BoardAge/Dashboard1/1.png