Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to track subjects that have been enrolled in concurrent years to create a cohort. I have data for 2011, 2014, and 2015.
I want to compare my current row (attendance) to previous row using a count if statement. This will become clearer when you view the attached spreadsheet.
My column headers are User Id, Year and Attendance.
I am trying to use the statement:
Count (If(Attendance='Y' and Above(Attendance) = 'Y',1,0))
I am getting a syntax error using "Above".
Thanks
David
Thank you very much for getting back to me... That seemed to work... Now I just have to understand the equation. I understand the If and Count portion... need to research the Aggr with the Year1, Year at the end of the function. Not sure how that works.
Again thank you very much for your help.