8 Replies Latest reply: Jun 28, 2016 2:26 PM by Lauren Mills RSS

    How do I write an expression to COUNT a Variable?

    Lauren Mills

      I created a variable to tell me whether a Student has passed a Class. It gives me either a "Y" or a "N".

       

      I wrote the expression as - Count($(vLevel0Completion)="Y"),[SID])

       

      (vLevel0Completion) is my variable the tells me Y or N

      [SID] is what I am trying to count (STUDENT) if they have a "Y" status within my variable.

       

      I am trying to put this expression into the KPI object. I'm currently getting a line and I am unable to figure out why I can't count. Let me know. All help is appreciated.