Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Excel 2000 Formula - Focus usiing wrong cells for totals

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Excel 2000 Formula - Focus usiing wrong cells for totals
 Login/Join
 
Jay
Gold member
posted
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 D2Big Grin10 and its really from D3Big Grin11.

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


WebFocus 7.6.6
Oracle 10
Windows XP
 
Posts: 60 | Registered: March 13, 2007Report This Post
FortuneCookie
Platinum Member
posted Hide Post
How about some sample code and release of WebFOCUS or Dev Studio?
 
Posts: 140 | Registered: May 02, 2007Report This Post
Jay
Gold member
posted Hide Post
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


WebFocus 7.6.6
Oracle 10
Windows XP
 
Posts: 60 | Registered: March 13, 2007Report This Post
Francis Mariani
Expert
posted Hide Post
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.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Tom Flynn
Expert
posted Hide Post
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...


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
 
Posts: 1972 | Location: Centennial, CO | Registered: January 31, 2006Report This Post
Jay
Gold member
posted Hide Post
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?


WebFocus 7.6.6
Oracle 10
Windows XP
 
Posts: 60 | Registered: March 13, 2007Report This Post
Brian Suter
Platinum Member
posted Hide Post
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


Brian Suter
VP WebFOCUS Product Development
 
Posts: 200 | Location: NYC | Registered: January 02, 2007Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Excel 2000 Formula - Focus usiing wrong cells for totals

Copyright © 1996-2020 Information Builders