Hi everyone, thank you for the replies! After reading your requests I will add further clarification to facilitate an answer. Clarification 1: Full date range spans 12 months starting in February. Point accrual could take place between February 1 and January 31 the following year. Clarification 2: The output above was an example re-arranging of my array into a list form to demonstrate the arithmetic. My actual data set uses 13 variables, (the person, and their point accrual for each month). Variables are actually in the form of Points_Mar, or Points_Feb etc. Clarification 3: Values can either be a null (.), a negative, or positive integer. Clarification 4: Output would basically be a re-arranging of point values per month to reflect the actual point totals. I would still have point totals by month, per person, but the monthly totals will have shifted by taking into account negative month totals. (Essentially, month totals which are negative will be aggregated toward the direction of the first month, decremented from positive months, and once subtracted from positive month totals, zeroed. The situation is basically month totals are determined my month totals upstream. Below is an example of three individuals, hypothetical sample data (Original) and what I'd like to accomplish via code (Modified). I have included a sample of my code so far as a first stab at conditional logic. /*January*/ IF Points_Jan < 0 THEN January = 0; ELSE IF Points_Jan >=0 THEN January = Points_Jan; /*December*/ IF January >= 0 AND Points_Dec >=0 THEN December = Points_Dec; ELSE IF January >=0 AND Points_Dec < 0 THEN December = 0; ELSE IF January < 0 AND Points_Dec >=0 THEN December = SUM(Points_Dec,Points_Jan) AND January = 0; ELSE IF January < 0 AND Points_Dec < 0 THEN December = SUM(Points_Dec,Points_Jan) AND January = 0; /*November*/ IF December >= 0 AND Points_Nov >=0 THEN November = Points_Nov; ELSE IF December >=0 AND Points_Nov < 0 THEN November = 0; ELSE IF December < 0 AND Points_Nov >=0 THEN November = SUM(Points_Nov,Points_Dec) AND December = 0; ELSE IF December < 0 AND Points_Nov < 0 THEN November = SUM(Points_Nov,Points_Dec) AND December = 0; TS
... View more