Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] ROW-TOTAL AND PERCENTAGE
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] ROW-TOTAL AND PERCENTAGE
 Login/Join
 
Gold member
posted
I have this following example using CAR file. The row-total percentage with across is the sum of the percentage, not the actual percentage. Anyone has any thoughts?

-************************
DEFINE FILE CAR
SALESD/D10 = SALES;
END
-***************************************
TABLE FILE CAR
SUM SALESD AS 'Sales' OVER
ROW-TOTAL AS 'TOTAL' OVER
PCT.SALESD/D6% WITHIN COUNTRY WITHIN SEATS AS '%'
BY COUNTRY
BY CAR
ACROSS SEATS
END
-*****************************
Result:
SEATS
2 4 5 TOTAL
COUNTRY CAR
ENGLAND JAGUAR Sales 0 . 12,000 12,000
% 0% . 100% 100%
JENSEN Sales . 0 . 0
% . 0% . 0%
TRIUMPH Sales 0 . . 0
% 0% . . 0%
FRANCE PEUGEOT Sales . . 0 0
% . . 0% 0%
ITALY ALFA ROMEO Sales 25,400 4,800 . 30,200
% 100% 100% . 200%
MASERATI Sales 0 . . 0
% 0% . . 0%
JAPAN DATSUN Sales . 43,000 . 43,000
% . 55% . 55%
TOYOTA Sales . 35,030 . 35,030
% . 45% . 45%
W GERMANY AUDI Sales . . 7,800 7,800
% . . 10% 10%
BMW Sales . 8,900 71,490 80,390
% . 100% 90% 190%


-**********************************************
Result should be:
SEATS
2 4 5 TOTAL
COUNTRY CAR
ENGLAND JAGUAR Sales 0 . 12,000 12,000
% 0% . 100% 100%
JENSEN Sales . 0 . 0
% . 0% . 0%
TRIUMPH Sales 0 . . 0
% 0% . . 0%
FRANCE PEUGEOT Sales . . 0 0
% . . 0% 0%
ITALY ALFA ROMEO Sales 25,400 4,800 . 30,200
% 100% 100% . 100%
MASERATI Sales 0 . . 0
% 0% . . 0%
JAPAN DATSUN Sales . 43,000 . 43,000
% . 55% . 55%
TOYOTA Sales . 35,030 . 35,030
% . 45% . 45%
W GERMANY AUDI Sales . . 7,800 7,800
% . . 10% 10%
BMW Sales . 8,900 71,490 80,390
% . 100% 90% 90%

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


Shirley Huang
WF 7.7.04M MRE BID DevStudio
WIN2003, SQL Server 2000/DB2
HTML/PDF/EXL2k/AHTML
iSM 6.16
 
Posts: 55 | Registered: May 05, 2006Reply With QuoteReport This Post
Virtuoso
posted Hide Post
DEFINE FILE CAR
SALESD/D10 = SALES;
SALEST/D10 = SALES;
END
-***************************************
TABLE FILE CAR
SUM SALEST NOPRINT 
 
BY COUNTRY
 
SUM SALESD OVER
 
-*PCT.SALESD/D7% WITHIN COUNTRY WITHIN SEATS
-*OVER
COMPUTE PCTNEW/D7%=C2/C1*100;
BY COUNTRY
BY CAR
ACROSS SEATS
ON TABLE ROW-TOTAL
 
ON TABLE NOTOTAL
END


Try this...it is a multiverb solution that might give you the result you need.




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

 
Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006Reply With QuoteReport This Post
Gold member
posted Hide Post
Thanks! It works!


Shirley Huang
WF 7.7.04M MRE BID DevStudio
WIN2003, SQL Server 2000/DB2
HTML/PDF/EXL2k/AHTML
iSM 6.16
 
Posts: 55 | Registered: May 05, 2006Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] ROW-TOTAL AND PERCENTAGE

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.