I have a very large file of demographic data, and I have fields such as TIME_PERIOD, which is each month, Jan, Feb, Mar. I have YEAR, TERM_DATE, as well as BEGIN_DATE and END_DATE, which give the beginning and ending dates for each month per employee's record. I am trying to count terminations per period, and I've tried several combinations of suggestions on this forum and none seem to give the correct answer. Can anyone provide a formula where in a chart I can calculate distinct terms per Month (TIME_PERIOD)?
Well its really just rows of employee numbers, termination dates, hire dates, and nulls for non termed employees. Each employee number has a TIME PERIOD, a BEGIN_DATE, and an END_DATE. I saw some other forums give examples like Re: count if date >= AND <= than value but I only want to count distinct instances of TERM_DATE per TIME_PERIOD.
