Jump to content

ROW-TOTAL % using ACROSS - How to Calculate correctly?


Kristi Carter

Recommended Posts

Both of your samples seem to make the total show up in the Across section and does not get me a TOTAL at the end.  I am looking to just get the total at the end and have it calculate correctly. 

Below shows what it does when I add

ACROSS-TOTAL AS 'Total' RECOMPUTE

OR

ACROSS CATEGORY RECOMPUTE

image.png.1d20cdc4506d2ee97d78ed71955189f9.png

 

Below is my code for when I added ACROSS-TOTAL AS 'Total' RECOMPUTE.

Am I needing to do something else to make it work?

TABLE FILE fmh_dw/hold_files/for_reports/master/clm_reset_tracking_sql_clu
SUM COMPUTE CLM_RESET_TRACKING_SQL_CLU.TTL_CNT;
-* COMPUTE CLM_RESET_TRACKING_SQL_CLU.PERC_OF_PD_TTL;
COMPUTE CLM_RESET_TRACKING_SQL_CLU.PERC_OF_PD_TTL_RESET;
BY CLM_RESET_TRACKING_SQL_CLU.CLM_RESET_TRACKING_SQL.CLM_ACTIVITY_TYPE_GRP_SORT NOPRINT
BY CLM_RESET_TRACKING_SQL_CLU.CLM_RESET_TRACKING_SQL.COND_FRMT_IND NOPRINT
BY CLM_RESET_TRACKING_SQL_CLU.CLM_RESET_TRACKING_SQL.CLM_ACTIVITY_TYPE_GRP SUBTOTAL SUM. CLM_RESET_TRACKING_SQL_CLU.TTL_CNT SUM. CLM_RESET_TRACKING_SQL_CLU.PERC_OF_PD_TTL SUM. CLM_RESET_TRACKING_SQL_CLU.PERC_OF_PD_TTL_RESET AS 'Subtotal:' MULTILINES
BY CLM_RESET_TRACKING_SQL_CLU.CLM_RESET_TRACKING_SQL.CLM_ACTIVITY_TYPE_NM
ACROSS CLM_RESET_TRACKING_SQL_CLU.CLM_RESET_TRACKING_SQL.PERF_MTH_N NOPRINT
ACROSS CLM_RESET_TRACKING_SQL_CLU.CLM_RESET_TRACKING_SQL.PERF_YR AS ' '
ACROSS CLM_RESET_TRACKING_SQL_CLU.CLM_RESET_TRACKING_SQL.PERF_MTH_NM AS ' '
ACROSS-TOTAL AS 'Total' RECOMPUTE
WHERE CLM_RESET_TRACKING_SQL_CLU.CLM_RESET_TRACKING_SQL.PERF_YR EQ &PERF_YR.(OR(FIND CLM_RESET_TRACKING_SQL_CLU.CLM_RESET_TRACKING_SQL.PERF_YR IN FMH_DW/HOLD_FILES/FOR_REPORTS/MASTER/CLM_RESET_TRACKING_SQL_CLU |FORMAT=A4,SORT=DESCENDING)).Performance Year.;
WHERE CLM_RESET_TRACKING_SQL_CLU.CLM_RESET_TRACKING_SQL.PERF_MTH_NUM_NM EQ &PERF_MTH_NUM_NM.(OR(FIND CLM_RESET_TRACKING_SQL_CLU.CLM_RESET_TRACKING_SQL.PERF_MTH_NUM_NM IN FMH_DW/HOLD_FILES/FOR_REPORTS/MASTER/CLM_RESET_TRACKING_SQL_CLU |FORMAT=A20,SORT=ASCENDING)).Performance Month.;
WHERE CLM_RESET_TRACKING_SQL_CLU.CLM_RESET_TRACKING_SQL.CLM_ANALYST EQ &CLM_ANALYST.(OR(FIND CLM_RESET_TRACKING_SQL_CLU.CLM_RESET_TRACKING_SQL.CLM_ANALYST IN FMH_DW/HOLD_FILES/FOR_REPORTS/MASTER/CLM_RESET_TRACKING_SQL_CLU |FORMAT=A81V,SORT=ASCENDING)).Reset User.;

ON TABLE PCHOLD FORMAT &WFFMT.(<Active,AHTML>,<Excel,XLSX>).Select an output type.

ON TABLE NOTOTAL
ON TABLE ROW-TOTAL  

 

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
  • Create New...