I created an app for a simple attendance register using barcodes. One of the tables for the lesson details has a field which is supposed to calculate the students recorded as present in the referenced table.
I used the expression:
COUNT(SELECT(Roaster[ScanCode],[LessonKey]=[_THISROW].[LessonID]))
The first time, the expression was working perfectly returning the number of students who would be recorded in the referenced table based on the scancode. Now it is always giving me a 0.
How do I resolve this?
I also verified and tested the expression. It is giving the right outcome but the result field continues to show a 0. Someone please help
LinkedIn
Twitter
