[CLOSED]How to get % at the bottom of the report

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: 29 | Registered: January 07, 2016

MartinY

Virtuoso

posted

Hide Post

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

Posts: 2409 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013

Ignored post by MartinY posted

Show Post

Leela Krishna

Silver 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: 29 | Registered: January 07, 2016

Ignored post by Leela Krishna posted