Essentially, the code below is succefully creating a running total for the 4 fields shown. The trouble is the running total should reset itself when the BaNbr changes.

It does not and I am unsure why?

TABLE FILE ANALYZER_INVOICE_VW
SUM
COMPUTE RUNNING_TOTAL_CHGS_ACT/D12.2 = ANALYZER_INVOICE_VW.TRANSACTION.TRX_CHARGE_AMOUNT + LAST RUNNING_TOTAL_CHGS_ACT; AS 'ChgsAct'
COMPUTE RUNNING_TOTAL_WRVUS_ACT/D12.2 = ANALYZER_INVOICE_VW.CPTCODES.wRVUs + LAST RUNNING_TOTAL_WRVUS_ACT; AS 'WrvusAct'
COMPUTE RUNNING_TOTAL_UNITS_ACT/D12.2 = ANALYZER_INVOICE_VW.CPTCODES.UNITS + LAST RUNNING_TOTAL_UNITS_ACT; AS 'UnitsAct'
COMPUTE RUNNING_TOTAL_VISIT_ACT/D12.2 = J1.TBLMSTR_CPTCODEPROCATXREF.VISIT_ACT + LAST RUNNING_TOTAL_VISIT_ACT; AS 'VisitsAct'
COMPUTE RUNNING_TOTAL_PROCEDURE_ACT/D12.2 = J1.TBLMSTR_CPTCODEPROCATXREF.PROCEDURE_ACT + LAST RUNNING_TOTAL_PROCEDURE_ACT; AS 'ProcsAct'
BY LOWEST ANALYZER_INVOICE_VW.INVOICE.Billing_Area_ReportingNum AS 'BaNbr'
BY LOWEST ANALYZER_INVOICE_VW.INVOICE.Billing_Area_ReportingName AS 'BaName'
BY LOWEST ANALYZER_INVOICE_VW.TRANSACTION.TRX_PostingDt_Period AS 'PD'
BY LOWEST ANALYZER_INVOICE_VW.TRANSACTION.TRX_PostingDt
WHERE ANALYZER_INVOICE_VW.TRANSACTION.TRX_PostingDt_Period EQ &TRX_PostingDt_Period.(AND(FIND TBLMSTR_CALENDARPERIOD.TBLMSTR_CALENDARPERIOD.PERIODTEXT,TBLMSTR_CALENDARPERIOD.TBLMSTR_CALENDARPERIOD.PERIODTEXT IN tblmstr_calendarperiod)).Select the desired Period/s.;
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE HOLD AS RNNGTOTALSACT FORMAT ALPHA
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = endeflt,
$
ENDSTYLE
END

This message has been edited. Last edited by: <Kathryn Henning>,

TABLE FILE CAR
SUM COMPUTE
    MODELCNT/D12 = CNT.MODEL ;
	COMPUTE
    CUM_MODELCNT/D12 = IF COUNTRY EQ LAST COUNTRY THEN (LAST CUM_MODELCNT + 1) ELSE MODELCNT ;
BY COUNTRY
BY MODEL
END  

Robert,

see the code using the CAR file. you can extend the logic for LAST to account for a change in some BY field. basically you want to the cumulative / running total to change for BaNbr

Hmmm...seems to make perfect sense but upon doing so, I loose my running totals alltogether...

TABLE FILE ANALYZER_INVOICE_VW
-*WHERE ( ANALYZER_INVOICE_VW.TRANSACTION.TRX_PostingDt_Period ) EQ &PRD
-* COMPUTE RUNNING_TOTAL_CHGS_ACT/D12.2 = IF ANALYZER_INVOICE_VW.INVOICE.Billing_Area_ReportingNum EQ LAST ANALYZER_INVOICE_VW.INVOICE.Billing_Area_ReportingNum THEN ANALYZER_INVOICE_VW.TRANSACTION.TRX_CHARGE_AMOUNT + LAST RUNNING_TOTAL_CHGS_ACT ELSE ANALYZER_INVOICE_VW.TRANSACTION.TRX_CHARGE_AMOUNT; AS 'ChgsAct'
-* COMPUTE RUNNING_TOTAL_UNITS_ACT/D12.2 = IF ANALYZER_INVOICE_VW.INVOICE.Billing_Area_ReportingNum EQ LAST ANALYZER_INVOICE_VW.INVOICE.Billing_Area_ReportingNum THEN ANALYZER_INVOICE_VW.CPTCODES.UNITS + LAST RUNNING_TOTAL_UNITS_ACT ELSE ANALYZER_INVOICE_VW.CPTCODES.UNITS; AS 'UnitsAct'
-* COMPUTE RUNNING_TOTAL_VISIT_ACT/D12.2 = IF ANALYZER_INVOICE_VW.INVOICE.Billing_Area_ReportingNum EQ LAST ANALYZER_INVOICE_VW.INVOICE.Billing_Area_ReportingNum THEN J1.TBLMSTR_CPTCODEPROCATXREF.VISIT_ACT + LAST RUNNING_TOTAL_VISIT_ACT ELSE J1.TBLMSTR_CPTCODEPROCATXREF.VISIT_ACT; AS 'VisitsAct'
-* COMPUTE RUNNING_TOTAL_PROCEDURE_ACT/D12.2 = IF ANALYZER_INVOICE_VW.INVOICE.Billing_Area_ReportingNum EQ LAST ANALYZER_INVOICE_VW.INVOICE.Billing_Area_ReportingNum THEN J1.TBLMSTR_CPTCODEPROCATXREF.PROCEDURE_ACT + LAST RUNNING_TOTAL_PROCEDURE_ACT ELSE J1.TBLMSTR_CPTCODEPROCATXREF.PROCEDURE_ACT; AS 'ProcsAct'
SUM
COMPUTE RUNNING_TOTAL_WRVUS_ACT/D12.2 = IF ANALYZER_INVOICE_VW.INVOICE.Billing_Area_ReportingNum EQ LAST ANALYZER_INVOICE_VW.INVOICE.Billing_Area_ReportingNum THEN ( ANALYZER_INVOICE_VW.CPTCODES.wRVUs + LAST RUNNING_TOTAL_WRVUS_ACT ) ELSE ANALYZER_INVOICE_VW.CPTCODES.wRVUs; AS 'WrvusAct'
BY LOWEST ANALYZER_INVOICE_VW.INVOICE.Billing_Area_ReportingNum AS 'BaNbr'
BY LOWEST ANALYZER_INVOICE_VW.INVOICE.Billing_Area_ReportingName AS 'BaName'
BY LOWEST ANALYZER_INVOICE_VW.TRANSACTION.TRX_PostingDt_Period AS 'PD'
BY LOWEST ANALYZER_INVOICE_VW.TRANSACTION.TRX_PostingDt
WHERE ANALYZER_INVOICE_VW.TRANSACTION.TRX_PostingDt_Period EQ &TRX_PostingDt_Period.(AND(FIND TBLMSTR_CALENDARPERIOD.TBLMSTR_CALENDARPERIOD.PERIODTEXT,TBLMSTR_CALENDARPERIOD.TBLMSTR_CALENDARPERIOD.PERIODTEXT IN tblmstr_calendarperiod)).Select the desired Period/s.;
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE HOLD AS RNNGTOTALSACT FORMAT ALPHA
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = endeflt,
$
ENDSTYLE
END

Cleaned it up...still no running total now...not sure why?

TABLE FILE ANALYZER_INVOICE_VW
SUM
COMPUTE CMPWRVUS/D12.2 = ANALYZER_INVOICE_VW.CPTCODES.wRVUs;
COMPUTE RUNNING_TOTAL_WRVUS_ACT/D12.2 = IF ANALYZER_INVOICE_VW.INVOICE.Billing_Area_ReportingNum EQ LAST ANALYZER_INVOICE_VW.INVOICE.Billing_Area_ReportingNum THEN ( LAST RUNNING_TOTAL_WRVUS_ACT + ANALYZER_INVOICE_VW.CPTCODES.wRVUs ) ELSE CMPWRVUS; AS 'WrvusAct'
BY ANALYZER_INVOICE_VW.INVOICE.Billing_Area_ReportingNum AS 'BaNbr'
BY LOWEST ANALYZER_INVOICE_VW.TRANSACTION.TRX_PostingDt
WHERE ANALYZER_INVOICE_VW.TRANSACTION.TRX_PostingDt_Period EQ 201307;
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET BYDISPLAY ON
ON TABLE NOTOTAL
ON TABLE HOLD AS RNNGTOTALSACT FORMAT ALPHA
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = endeflt,
$
ENDSTYLE
END

Interesting...I put a switch in there (below)and ran the report with just the switch...it appears to correctly flip from Y to N as the BaNbr changes...I am thinking that the running total is suddenly not working do to some ort of syntax issue?

COMPUTE SWITCH/A1 = IF ANALYZER_INVOICE_VW.INVOICE.Billing_Area_ReportingNum EQ LAST ANALYZER_INVOICE_VW.INVOICE.Billing_Area_ReportingNum THEN 'Y' ELSE 'N'; AS 'Switch'

****CLOSED***********

This code appears to work...


TABLE FILE ANALYZER_INVOICE_VW
BY LOWEST ANALYZER_INVOICE_VW.INVOICE.Billing_Area_ReportingNum AS 'BaNbr'
BY LOWEST ANALYZER_INVOICE_VW.TRANSACTION.TRX_PostingDt
BY LOWEST COMPUTE SWITCH/A1 = IF ANALYZER_INVOICE_VW.INVOICE.Billing_Area_ReportingNum EQ LAST ANALYZER_INVOICE_VW.INVOICE.Billing_Area_ReportingNum THEN 'Y' ELSE 'N'; AS 'Switch'
BY LOWEST COMPUTE RUNNING_TOTAL_WRVUS_ACT/D12.2 = IF ANALYZER_INVOICE_VW.INVOICE.Billing_Area_ReportingNum EQ LAST ANALYZER_INVOICE_VW.INVOICE.Billing_Area_ReportingNum THEN ( LAST RUNNING_TOTAL_WRVUS_ACT + ANALYZER_INVOICE_VW.CPTCODES.wRVUs ) ELSE ANALYZER_INVOICE_VW.CPTCODES.wRVUs; AS 'WrvusRnng'
WHERE ANALYZER_INVOICE_VW.TRANSACTION.TRX_PostingDt_Period EQ 201307;
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET BYDISPLAY ON
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
-*ON TABLE HOLD AS RNNGTOTALSACT FORMAT ALPHA
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = endeflt,
$
ENDSTYLE
END

Robert (and others): I know the standard advice these days is to use fully-qualified field names in your code, but when posing (or even posting) on here it makes it a LOT easier to understand what you are getting at if you either use the CAR file or alternatively simplify your code.

For example:

COMPUTE RUNNING_TOTAL/D12.2 = IF ReportingNum EQ LAST ReportingNum THEN ( LAST WRVUS_ACT + wRVUs ) ELSE CMPWRVUS;

I will do so in the future.