calculation with firstsortedvalue, sum, set, help please

[shahamel]

Dear QV-users

I want to make this calculation:

(PEOPLE_GRADUATED * 100) / TOTAL_PEOPLE

TOTAL_PEOPLE = COUNT ALL PEOPLE

PEOPLE GRADUATED =

TYPE_ONDERWIJS = BO     AND

STARTOCTOBER <= DATE_EXIT     AND

DATE_EXIT < TODATE AND

(SUCCES = 1 AND X = 1) OR (LEAVVE = 1 AND Y=1)

X = COUNT PEOPLE

     WHERE SUCCES = 1

     STARTOCTOBER = SCHOOLSTART AND

     DATE_EXIT < TODATE

// i want to use firstsortedvalue for sort by.

   SORT BY

          KWALIFICATION DESC

          FUNDED

          SIZE EDUCATION

          ISNULL(DATE_EXIT, DATE_ENDPLANNED) DEC

          CONNECTION NUMBER

Y = COUNT PEOPLE

     WHERE EXIT = 1

     STARTOCTOBER = SCHOOLSTART AND

     DATE_EXIT < TODATE

// i want to use firstsortedvalue for sort by.

   SORT BY

          IF(SUCCES NOTNULL, KWALIFICATION, ElSE 'NIVEAU0)'

          FUNDED

          SIZE EDUCATION

          ISNULL(DATE_EXIT, DATE_ENDPLANNED) DEC

          KWALIFICATION DESC

          CONNECTION NUMBER

Good luck