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     [CLOSED]How to get % at the bottom of the report
Go
New
Search
Notify
Tools
Reply
  
[CLOSED]How to get % at the bottom of the report
 Login/Join
 
Member
posted
Hi Everyone,
First of all cheers to those who have been helping others to write the code in a better way.
We have a report where I used SQL pass thru to get columns. Few of the columns have 'Y' or 'N' values(records) only. My question is I want to display (N/Y+N)*100 (Percentage of N's in that column) only for those columns at the bottom of report. Please let me know, how do I do it. Thanks in advance.
Regards
Krishna

This message has been edited. Last edited by: <Emily McAllister>,


WebFOCUS 8
Windows, All Outputs
 
Posts: 27 | Registered: January 07, 2016Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Could be one way to do it with a wink to our friends in UK Wink
DEFINE FILE CAR
EURO      /A1 = DECODE COUNTRY ('ITALY' 'Y' 'FRANCE' 'Y' ELSE 'N');
ISNOTEURO /P2 = IF EURO EQ 'Y' THEN 0 ELSE 1;
NBREC     /P2 = 1;
END
TABLE FILE CAR
SUM ISNOTEURO
    NBREC
    COMPUTE PCT /P6.2C% MISSING ON = MISSING;
BY TOTAL COMPUTE BIDON /D1  = 1;
BY MODEL
BY EURO
ON TABLE HOLD AS DET FORMAT FOCUS
END
-RUN

TABLE FILE DET
SUM ISNOTEURO
    NBREC
    COMPUTE PCT /P6.2C% = ISNOTEURO / NBREC * 100;
BY TOTAL COMPUTE BIDON /D1  = 9;
BY TOTAL COMPUTE MODEL /A24 = '% Of Is Not EURO';
BY TOTAL COMPUTE EURO  /A1  = '';
ON TABLE HOLD AS TOT FORMAT FOCUS
END
-RUN

TABLE FILE DET
SUM PCT
BY BIDON NOPRINT
BY MODEL
BY EURO
MORE
FILE TOT
END
-RUN


WF versions : Prod 8.2.0.1M gen 240, Dev 8.2.04 gen 48, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
 
Posts: 2191 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Reply With QuoteReport This Post
Member
posted Hide Post
Hi Martin,
That solution helped me to solve my issue. Thank you very much

Regards
Krishna


WebFOCUS 8
Windows, All Outputs
 
Posts: 27 | Registered: January 07, 2016Reply With QuoteReport This Post
Guru
posted Hide Post
Good One


WebFOCUS 8.1.05 / APP Studio
 
Posts: 272 | Location: Brazil | Registered: October 31, 2006Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED]How to get % at the bottom of the report

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