We are developing a report in 7.7.03 which will be formatting to exl2k. In the Computes we were using the LAST function which was not working correctly. Since excel2k w/LAST is not supported, does anyone have a different technique? This is multi-Veb request if that makes a difference. Bottom line, trying to get away from the Circular reference displayed from Excel.

We decided to use launch forms that will allow the users to make changes rather than to programtically try to make the changes for them. Thank you for all your suggestions.

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

I managed to create a multi-verb request which makes use of LAST to calculate a running total and displays results in EXL2K.

TABLE FILE CAR
SUM 
     COMPUTE TOT_SALES/I10 = SALES; AS 'Total,Sales'
BY  LOWEST CAR.ORIGIN.COUNTRY AS 'Country'
PRINT 
     CAR.CARREC.MODEL AS 'Model'
     CAR.BODY.SALES AS 'Sales'
     COMPUTE SALES_PCT/D8.1% = ( SALES / TOT_SALES ) * 100; AS 'Sales %'
     COMPUTE RUN_TOT/I10 = IF COUNTRY NE LAST COUNTRY THEN SALES ELSE RUN_TOT + SALES; AS 'Running,Total'
BY  LOWEST CAR.ORIGIN.COUNTRY AS 'Country'
BY  LOWEST CAR.COMP.CAR AS 'Car'
     
ON CAR.ORIGIN.COUNTRY SUBFOOT
" "
ON TABLE SET PAGE-NUM NOLEAD 
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     INCLUDE = endeflt,
$
ENDSTYLE
END

Perhaps there's something else in your report that maybe causing the issue you describe.

Could you work an example using the CAR table illustrating what your problem is?

With a few minor changes, the report can actually be displayed in EXL2K FORMULA:

TABLE FILE CAR
SUM 
     COMPUTE TOT_SALES/I10 = SALES; NOPRINT
BY  LOWEST CAR.ORIGIN.COUNTRY AS 'Country'
PRINT 
     CAR.CARREC.MODEL AS 'Model'
     CAR.BODY.SALES AS 'Sales'
     COMPUTE SALES_PCT/D8.1% = IF TOT_SALES EQ 0 THEN 0 ELSE ( SALES / TOT_SALES ) * 100; AS 'Sales %'
     COMPUTE RUN_TOT/I10 = IF COUNTRY NE LAST COUNTRY THEN SALES ELSE RUN_TOT + SALES; AS 'Running,Total'
BY  LOWEST CAR.ORIGIN.COUNTRY NOPRINT
BY  TOT_SALES AS 'Total,Sales'
BY  LOWEST CAR.COMP.CAR AS 'Car'
     
ON CAR.ORIGIN.COUNTRY SUBFOOT
" "
ON TABLE SET PAGE-NUM NOLEAD 
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT EXL2K FORMULA
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     INCLUDE = endeflt,
$
ENDSTYLE
END

Thanks - I will let you know the results.