Guest User

Untitled

a guest
Jan 17th, 2018
85
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.97 KB | None | 0 0
  1. ADMIT_TERM ADMIT_TYPE GRAD_YEAR
  2. 200708 F 2011
  3. 200708 F 2011
  4. (...) (...) (...)
  5.  
  6. =COUNTIFS(data[ADMIT_TERM],[@[admit_term]],data[GRAD_YEAR],[@[cohort_student_year]], data[ADMIT_TYPE],"F")
  7.  
  8. =IF(ISNUMBER(FIND("First Year",[@[student_year]])), 0, SUM([@[grad_count_ftic_by_student_year]],K1))
  9.  
  10. student_year grad_count_ftic_(...)_year cumulative_grad_ftic
  11. First Year 0 0
  12. Second Year 0 0
  13. Third Year 1 1
  14. Fourth Year 114 115
  15. Fifth Year 15 129
  16. Sixth Year 4 133
  17.  
  18. grad_count_ftic_by_student_year cumulative_grad_ftic
  19. 0 0
  20. 0 0
  21. 0 0
  22. 1 1
  23. 114 115
  24. 14 128
Add Comment
Please, Sign In to add comment