I created a Beast Mode calculation to extract the academic year based on term codes. For example, to derive the academic year 1955-1956, I identified these three term codes: 1555, 1561, and 1563. 1555 is Fall 1955. The 2 digits in between are the year. (The last digit ‘5’ represents Fall). 1561 is Winter 1956. (The last…
I have two datasets: one for home country and another for citizenship. Both datasets share two common columns: country and student_id. In the home country dataset, the country column is 70% populated, leaving 30% of the rows as null. I want to fill these null values in the home country dataset using the corresponding…
14.76K is the total number of students (Both full-time and part-time). What would be the formula if I only want to count the Full-time values in the Full-time/Part-time column? And then if I want to change the count to percentage, do I need another formula for it? Thank you.
