One of My report calculates the percentages. When I use compute my perentage calculation in procedure doesnt show correct results. I was wondering if you can give me some ideas to resolve this problem.
Following CODE works fine

 TABLE FILE AGG_ENROLLMENT
 SUM
     &UNIT1_FIELD/A25    AS 'UNIT1'
     &UNIT2_FIELD/A25    AS 'UNIT2'
   ENROLLEDACTIVE  AS 'ENROLLED'
-*End Code change for Lsat Week
          EnrolledUnscheduled AS 'UNSCHED'
     NewEnroll           AS 'NEWENROLL'
     Withdraw            AS 'WITHDRAW'
	 &BURST
  BY FYPW
  BY LITM2
  BY LITM3
  BY &UNIT1_FIELD     NOPRINT
  BY &UNIT2_FIELD     NOPRINT
 WHERE &UNIT1_WHFIELD EQ '&UNIT1_VAL'
 WHERE FYPW LE '&FYPW_0'
 WHERE FYP EQ '&FYP_0'
    OR FYP EQ '&FYP_1'
    OR FYP EQ '&FYP_2'
    OR FYP EQ '&FYP_3'
    OR FYP EQ '&FYP_12'
    OR FYP EQ '&FYP_13'
ON TABLE HOLD AS ENRLAGGX FORMAT FOCUS

END
?FF ENRLAGGX
-RUN 

BUT FOLLIWNG CODE messes up percentae calculations in other procedure.

  
TABLE FILE AGG_ENROLLMENT
 SUM
     &UNIT1_FIELD/A25    AS 'UNIT1'
     &UNIT2_FIELD/A25    AS 'UNIT2'

COMPUTE NEWSUM2/D12.2 = 
 IF FYP EQ '&FYP_0' THEN ENROLLEDACTIVE + ENROLLEDUNSCHEDULED  ELSE IF (EDIT(FYPW,'999999') NE '&FYP_0') AND (EDIT(FYPW,'$$$$99$') EQ '03' OR '06' OR '09' OR '12') AND (EDIT(FYPW,'$$$$$$9') EQ '5')  THEN ENROLLEDACTIVE + ENROLLEDUNSCHEDULED  ELSE IF (EDIT(FYPW,'999999') NE '&FYP_0') AND (EDIT(FYPW,'$$$$99$') EQ '01' OR '02' OR '04' OR '05' OR '07' OR '08' OR '10' OR '11') AND EDIT(FYPW,'$$$$$$9') EQ '4'
 THEN ENROLLEDACTIVE + ENROLLEDUNSCHEDULED ELSE 0; AS 'ENROLLED'

          EnrolledUnscheduled AS 'UNSCHED'
     NewEnroll           AS 'NEWENROLL'
     Withdraw            AS 'WITHDRAW'
	 &BURST
  BY FYPW
  BY LITM2
  BY LITM3
  BY &UNIT1_FIELD     NOPRINT
  BY &UNIT2_FIELD     NOPRINT
 WHERE &UNIT1_WHFIELD EQ '&UNIT1_VAL'
 WHERE FYPW LE '&FYPW_0'
 WHERE FYP EQ '&FYP_0'
    OR FYP EQ '&FYP_1'
    OR FYP EQ '&FYP_2'
    OR FYP EQ '&FYP_3'
    OR FYP EQ '&FYP_12'
    OR FYP EQ '&FYP_13'
ON TABLE HOLD AS ENRLAGGX FORMAT FOCUS

END
?FF ENRLAGGX
-RUN

This message has been edited. Last edited by: Kerry,

We have no idea what your data or metadata looks like, what values are being filled in for your parameter values, and nowhere in here is there any code indicating anything about a percentage calculation. You've got to be a little more specific about what you're tyring to do and what the problem is before anyone can help you.