I request your help to be able to solve the setback that the following situation generates:
Not being able to obtain the name in the report (Image below) that I generate through a virtual column, which depends on two dates, start and end. The virtual column extracts the student’s name (Student ID) from the payments table, since the payments table is referenced to the student registration table.
I’ve tried lookup, but it doesn’t work because of the column type difference (list and text).
You can guide me which formula to use to extract the name of the payments table.
Thank you very much for your support.