I am trying to use the Count() Summary Function in a Query Calculation member. I am attaching images of what the Query Structure looks like for a better visual understanding. What I am trying to do, is get a count of how many records show a Discrepancy values <> 0, within each group of "ITEM_DESC". I wrote the following code, but ReportNet complains of bad syntax... Is there a way to do what I am looking for?
count(DISTINCT [STUDENT_KEY] for [ITEM_DESC], [SCOREDIFFERENCE] <> 0)