I am trying to show the summary of years members have participated in a non-profit.
There are five fields: Name, Active (checkbox), Date Joined, Date Left, Years of Membership
The table has both active and inactive members. I am using the time diff formula, however, for the members that are still active, the Date Left category returns NaN value.
Is there a way of calculating a Years of Membership for both active and inactive members in the same column?