When I change my report from excel 2000 to excel 2000 formula, my total numbers go wrong.

The reason for this is that the excel 2000 formula says the total is from D210 and its really from D311.

Is this a bug, or do I have to do something in my Focus code to prevent this from happening.

How about some sample code and release of WebFOCUS or Dev Studio?

Here is the code - according to the customer, when he uses skip-line the problem occurs, with out skip-line it works. Again this happens only with excel 2k with formulas.


TABLE FILE 1391DRY3
SUM
REQAMT_ALL1/P16.2BC AS 'AMOUNT,EXPENDED'
FED_ALL AS 'FEDERAL,AMOUNT,REQUISITIONED'
COMPUTE LOCAL_AMT/P16.2BC = REQAMT_ALL1 - FED_ALL; AS 'LOCAL,FUNDING'
FED_PRIOR AS 'FEDERAL,FUNDS,RECEIVED'
COMPUTE FED_NEW/D15.2BC = FED_ALL - FED_PRIOR;
AS 'FEDERAL,REQUISITIONS,IN PROCESS'
BY FS_DETAILX AS 'SOURCE ,DETAIL'
BY CONTRACT_ID AS 'CONTRACT,NUMBER'
BY CONTRACT_LINE_NUMBER AS 'LN'
BY COMMITMENT_ID AS 'COMMITMENT,NUMBER'
BY TASK_ID AS 'TASK'
BY DESCRIPT AS 'TASK DESCRIPTION'

ON FS_DETAILX SUBTOTAL AS '*TOTAL'
ON FS_DETAILX SKIP-LINE
HEADING
" "
"PAGE " "
"FEMA GRANT : 1391DRNY "
"SUMMARY OF GRANT ACTIVITY"
"AS OF 09/30/2007"
" "
FOOTING
"FILE:WEBFOCUS/IMPACT/FEMA 1391DRNY"
WHERE REQAMT_ALL1 NE .00 OR FED_ALL NE .00 OR FED_PRIOR NE .00;
WHERE AGCY NE ' ';
ON TABLE SET PAGE-NUM OFF
ON TABLE COLUMN-TOTAL AS 'TOTAL'
ON TABLE PCHOLD FORMAT EXL2K FORMULA
ON TABLE SET STYLE *
UNITS=IN,
PAGESIZE='Legal',
LEFTMARGIN=0.250000,
RIGHTMARGIN=0.250000,
TOPMARGIN=0.250000,
BOTTOMMARGIN=0.250000,
SQUEEZE=ON,
ORIENTATION=LANDSCAPE,
$
TYPE=REPORT,
GRID=OFF,
FONT='TIMES NEW ROMAN',
SIZE=10,
COLOR='BLACK',
BACKCOLOR='NONE',
STYLE=NORMAL,
$
TYPE=DATA,
COLUMN=N10,
SIZE=10,
$
TYPE=DATA,
COLUMN=N11,
SIZE=10,
$
TYPE=DATA,
COLUMN=N8,
SIZE=10,
$
TYPE=DATA,
COLUMN=N9,
SIZE=10,
$
TYPE=DATA,
COLUMN=N7,
SIZE=10,
$
TYPE=DATA,
COLUMN=N4,
SIZE=10,
$
TYPE=DATA,
COLUMN=N3,
SIZE=10,
$
TYPE=DATA,
COLUMN=N5,
SIZE=10,
$
TYPE=DATA,
COLUMN=N2,
SIZE=10,
$
TYPE=TITLE,
COLUMN=N10,
SIZE=10,
$
TYPE=TITLE,
COLUMN=N11,
SIZE=10,
$
TYPE=TITLE,
COLUMN=N8,
SIZE=10,
$
TYPE=TITLE,
COLUMN=N9,
SIZE=10,
$
TYPE=TITLE,
COLUMN=N7,
SIZE=10,
$
ENDSTYLE
END

As per Friendly reminder: Please update your signatures it would be nice for both of you to update your signatures in your FocalPoint profiles.

I abandoned use of EXL2K formula as I found it was not reliable - it worked in some cases and didn't work in others, particularly when used with FML - FOR, RECAP, OVER would mucjk up the formulas.

Jay/Francis,

I use EXL2K FORMULA "only" with SUBTOTAL, SUB-TOTAL, SUMMARIZE and RECOMPUTE.

Skipping any lines, using SKIP-LINE, SUBFOOT, etc., WF will not generate the correct cell formula's.

Haven't heard anything on fixes in new releases.

FYI...

IBI - DO YOU HAVE A FIX FOR THIS? DO YOU KNOW ABOUT THIS PROBLEM? IF YOU DON'T HAVE A FIX, WHEN DO YOU EXPECT TO HAVE A FIX?

There was a problem fixed in 537, 717, and 761. A simple repro of the problem looks like:
TABLE FILE CAR
SUM SEATS DCOST RCOST
BY COUNTRY SUBTOTAL SKIP-LINE
BY CAR
ON TABLE PCHOLD FORMAT EXL2K FORMULA
END