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 KrishnaThis message has been edited. Last edited by: <Emily McAllister>,
WebFOCUS 8 Windows, All Outputs
June 30, 2016, 03:10 PM
MartinY
Could be one way to do it with a wink to our friends in UK
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.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF In Focus since 2007
July 06, 2016, 01:12 PM
Leela Krishna
Hi Martin, That solution helped me to solve my issue. Thank you very much