How does one perform a running total in Web Focus

[robert fuschetto]

I was hoping it would be an option under aggregation, but it is not.

[Mat Barnard]

Look up the RUNNING_SUM function.

[robert fuschetto]

I am using App Studio.

This seems to work for the CARS file:

TABLE FILE CAR

SUM RCOST

COMPUTE RUN_TOT=LAST RUN_TOT + RCOST;

BY COUNTRY

END

 

Yet this code does not work for my file.

WHAT AM I MISSING HERE?

TABLE FILE TBLMSTR_CHGUNITWRVUSTATSBYDAY

SUM WRVUS

COMPUTE WRVUS_RT = LAST WRVUS_RT + WRVUS ;

BY  POST_DATE

WHERE RPTBANBR EQ 30062 AND PROVIDERNAME EQ 'MARKOWITZ, MOSHE';

END

 

[David Briars]

Not sure if RUNNING_SUM is in my release 8207.28, so I might look at using the LAST function to accumulate:

TABLE FILE CARSUM SALES/D6COMPUTE SALES_RT/D6 = IF COUNTRY EQ LAST COUNTRY THEN SALES_RT + SALES ELSE SALES; AS 'SALES, RUNNING_TOTAL' RETAIL_COSTCOMPUTE RETAIL_COST_RT/D6 = IF COUNTRY EQ LAST COUNTRY THEN RETAIL_COST_RT + RETAIL_COST ELSE RETAIL_COST; AS 'RETAIL COST, RUNNING_TOTAL'BY COUNTRYBY CARON GRAPH SET STYLE * INCLUDE=IBFS:/FILE/IBI_HTML_DIR/javaassist/intl/EN/combine_templates/ENWarm.sty,$ENDSTYLEEND

[robert fuschetto]

Well, this runs fine:

TABLE FILE CAR

SUM RCOST

COMPUTE RUN_TOT=LAST RUN_TOT + RCOST;

BY COUNTRY

I see no difference in my code:

TABLE FILE TBLMSTR_CHGUNITWRVUSTATSBYDAY

SUM WRVUS

COMPUTE WRVUS_RT = LAST WRVUS_RT + WRVUS ;

BY  POST_DATE

Do you see a change I'd need t make?

WHERE RPTBANBR EQ 30062 AND PROVIDERNAME EQ 'MARKOWITZ, MOSHE';

END

[David Briars]

Yep, I agree it looks like your code ties back to the model code. 😎

Is there a chance there is a field called 'WRVUS_RT' in your master? If so, you would want to give your COMPUTEd field a unique name.

[robert fuschetto]

NO! However, I did change from WRVUS_RT to WRVUS_RUNTOT and now it works!

 

Thanks for the suggestion...if I had time I'd open a case w/IBI to see what gives!

[David Beagan]

Looking at past function manuals, it seems that the RUNNING_SUM funtion started with the 8.2.xx release. Interestingly, the latest 9.1 functions manual still shows an example of how to do a running sum using the LAST function, as well as, an exmple with RUNNING_SUM.

[David Briars]

@Robert Fuschetto​ Glad it worked. (Maybe there is a field in the master that begins with 'WRVUS_RT'?)

@David Beagan​  Ohhh.... 'RUNNING_SUM' is a function. I see it now in the 'Using Functions' manual; was looking in the 'Creating Reports' manual. Thank you!

[robert fuschetto]

is that in v8.207v28?

[David Beagan]

@Robert Fuschetto​ Are you asking if RUNNING_SUM is in v8.207v28 ?