Forum Discussion
Expand count() to allow if statement to return data from different table
Hi, I'm trying to work out the year grade for enrolled students. We have two tables, one where we store the pupil data and another storing their school history, sometimes for future leavers the ...
Thanks for your feedback. I tried your suggestion but couldn't get it working. I've added an edited section with my expected output.
v-piga-msft
Resident Rockstar
Resident RockstarHi MBegum ,
Sorry for the delay.
However, what is the PupilSession[LeavingDate]? It seems that you have the third table PupilSession?
If it is convenient, could you also share the sample data of the table PupilSession?
Best Regards,
Cherry