Subtotal computation

Hi,

I'm trying to do computations on a subtotal field but don't know how to do it. Pls. see sample report output below:

COMPROD VALUE1 VALUE2 RATIO
A1 3583 3616 99
A1 71283 72320 99
A1 -16 0 0
A1 1808 1662 109
Total A1 76658 77598 99

Comprod, Value1 and Value2 are actual values and should be summed at the subtotal. Ratio is a computation: (Value 1/Value 2) * 100. On the subtotal, it should compute are (76658/77598) * 100. The result is 99. However, when I run my report, it sums up the Ratio field and displays 406.

Thanks for your help.

Dev: WebFOCUS 7.6.10, Data Migrator 7.6.10
QA: WebFOCUS 7.6.10, Data Migrator 7.6.10
Prod: WebFOCUS 7.6.2, Data Migrator 7.6.8
Windows 2K3, Tomcat 5.5.17, IIS 6
Usage: HTML, PDF, Excel, Self-serve, BID and MRE

Posts: 197 | Location: Roseville, CA | Registered: January 24, 2005

Leah

Virtuoso

posted

Hide Post

Look into the summarize and recompute verb objects.

Try

ON TABLE SUMMARIZE or
ON TABLE RECOMPUTE

Replace TABLE with your sort field name if you are wanting subtotals on a sort value.

Leah

Posts: 1317 | Location: Council Bluffs, IA | Registered: May 24, 2004

Ignored post by Leah posted

Show Post

dballest

Platinum Member

posted

Hide Post

Hi Leah,

It still did not work for me. Below is my code:
DEFINE FILE TEMPHOLD
NEWDIEPERWAFERRATIO/D20%=(ACUTALDIEPERWAFER/BUDGETDIEPERWAFER) * 100;
END

TABLE FILE TEMPHOLD
PRINT
ACUTALDIEPERWAFER/D20 AS 'Actual,D/W,'
BUDGETDIEPERWAFER/D20 AS 'Std,D/W,'
NEWDIEPERWAFERRATIO
BY
PROJECT AS 'Project,'

ON PROJECT RECOMPUTE AS '*TOTAL'
WHERE REPORTBY EQ 'DPN';
ON TABLE NOTOTAL
END
-EXIT

NEWDIEPERWAFERRATIO is still being totaled instead of RECOMPUTE at the Project break.

Posts: 197 | Location: Roseville, CA | Registered: January 24, 2005

Ignored post by dballest posted

Show Post

Darin Lee

Virtuoso

posted

Hide Post

You have to create the field NEWDIEPERWAFERRATIO in a COMPUTE instead of a DEFINE. This should give you what you want.

Regards,

Darin

In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat

Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007

Ignored post by Darin Lee posted

Show Post

FrankDutch

Virtuoso

posted

Hide Post

and that would be done this way

DEFINE FILE TEMPHOLD
-*NEWDIEPERWAFERRATIO/D20%=(ACUTALDIEPERWAFER/BUDGETDIEPERWAFER) * 100;
END

TABLE FILE TEMPHOLD
PRINT
ACUTALDIEPERWAFER/D20 AS 'Actual,D/W,'
BUDGETDIEPERWAFER/D20 AS 'Std,D/W,'
COMPUTE NEWDIEPERWAFERRATIO/D20%=(ACUTALDIEPERWAFER/BUDGETDIEPERWAFER) * 100;
BY
PROJECT AS 'Project,'
ON PROJECT RECOMPUTE AS '*TOTAL'
WHERE REPORTBY EQ 'DPN';
ON TABLE NOTOTAL
END

	*Frank*
	prod: WF 7.6.10 platform Windows, databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7 test: WF 7.6.10 on the same platform and databases,IE7