7 Replies Latest reply: Nov 13, 2012 3:41 AM by Tim Hop RSS

    Expression Query

      Hi everyone.

      i am struggling with writing an expression for the following.

       

      I want to a count of all the distinct [PupilID] which meet the following criteria.

       

      they must have a [APSScore] of more than 1. the [APSScore] is worked out by deducting [Chrono]={7} from [Chrono]={6} and by only looking at [LevelScore]='Score'.

      Does this make sense?

      Can anyone help please?

       

      thanks