Average of PCT across a field

Hi,

I need to have a row total (an average) of PCT data across a particular field. Below is a code using the CAR file.

TABLE FILE CAR
SUM PCT.RC
BY BODYTYPE
ACROSS COUNTRY
END
-EXIT

The output and required average snapshot is posted at http://tinypic.com/view.php?pic=jt7a12&s=3

So, for SEDAN,it comprises 69% for ENGLAND and 76.2% across all the countries.

Thanks in advance for your help.

Dan

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

Tom Flynn

Expert

posted

Hide Post

dballest,

Click SEARCH, enter ACROSS PERCENT, click GO, and VOILA!

Tom

Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe

Posts: 1972 | Location: Centennial, CO | Registered: January 31, 2006

Ignored post by Tom Flynn posted

Show Post

dballest

Platinum Member

posted

Hide Post

No luck Tom. If you look at the ENGLAND column, it contain PCT of the data by bodytype. Total for each column is always 100%

The last column AVERAGE is an average of the PCT by bodytype across country (which is variable number of countries).

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

Ignored post by dballest posted

Show Post

mgrackin

Virtuoso

posted

Hide Post

Because you are taking an average of the PCT values, you need to HOLD the data first and then use a multi-verb request with a COMPUTE after the ACROSS to get what you want.

TABLE FILE CAR
SUM PCT.RETAIL_COST WITHIN COUNTRY
BY COUNTRY
BY BODYTYPE
ON TABLE HOLD AS THEDATA
END
-RUN
TABLE FILE THEDATA
SUM AVE.RETAIL_COST NOPRINT
BY BODYTYPE
SUM RETAIL_COST
BY BODYTYPE
ACROSS COUNTRY
COMPUTE AVERC/D3%=C1;
END

Thanks!

Mickey