0 Replies Latest reply: Jul 24, 2013 3:52 AM by Sandeep Hamelink RSS

    using result of a variable in an expression

    Sandeep Hamelink

      Dear users,

       

       

      I would like to see if a person passed his examen (geslaagd = 1) when he leaves (uitstroom = 1) school.

       

      This is what i think i should do, the point is that this doesn't not work.

       

      This formule should count all 'deelnemersnrs' who got their diploma at least once.

       

      count(

                 where geslaagd = 1

                            if a person studies 4 year and gets a diploma (geslaagd = 1) during it's second year ,but does not

                           pass his examen (geslaagd = 0) during it's fourht year it still count's as 1, because during it's time in

                           school he has passed his examen at least once

                where uitstroom = 1

      Deelnemernr

       

      This formule should count all 'deelnemernrs' who didn't got their diploma.

       

      count(

                 where geslaagd = 0

                            if a person studies 4 year and did not get his diploma during that period

                where uitstroom = 1

      Deelnemernr

       

      Please help,

       

      Gr. Sandeep