Hello,

The ROW-TOTAL is giving me the Grand total, Which is fine. The user want to see the current year total(Ex.2017) as well. I am trying to do subtract the (ROW-TOTAL - LASTYR ) to get the result . but I am not getting the right result. I appreciate any one help me on this.

This is part of my code from report:

 TABLE FILE HOLD
SUM
LASTYR  AS ''
BY PRVPLANCNT  AS ''
SUM
CURRCNT
ROW-TOTAL/L/D12 AS 'Grand Total'
BY PRVPLANCNT AS ''
ACROSS Month NOPRINT
ACROSS AlphaMonth AS 'Plan Name                    &LASTYR'
END 

This message has been edited. Last edited by: FP Mod Chuck,

Hello,
Please see the below code,I got the total and grand total but it is putting in 2nd and 3rd field. I would like show the total and grand total at the end last field. I appreciate any one have suggestion.

 

TABLE FILE HOLD
SUM
LASTYR  AS ''
BY PRVPLANCNT  AS ''

SUM
CURRCNT  AS '&YR Total'
COMPUTE GRANDTOTAL/D13= CURRCNT +  LASTYR;  AS 'Grand Total'
BY PRVPLANCNT AS ''

SUM
CURRCNT 
BY PRVPLANCNT AS ''
ACROSS AlphaMonth                                       
END
 

This could be an option

SET ASNAMES = ON
TABLE FILE HOLD
SUM LASTYR  AS 'TOT_LY'
    CURRCNT AS 'TOT_TY'
    COMPUTE GRANDTOTAL/D13= CURRCNT + LASTYR;
BY PRVPLANCNT
ON TABLE HOLD AS TOT FORMAT FOCUS INDEX PRVPLANCNT
END
-RUN

JOIN 
     PRVPLANCNT IN HOLD 
  TO PRVPLANCNT IN TOT TAG J1 AS J1
END

TABLE FILE HOLD
SUM CURRCNT
    TOT_LY     AS 'LY Total'
    TOT_TY     AS '&YR Total'
    GRANDTOTAL AS 'Grand Total'
BY PRVPLANCNT  AS ''
ACROSS AlphaMonth                                       
END
-RUN