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] Count Feature
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] Count Feature
 Login/Join
 
Gold member
posted
I have a column that i have used a CNT.DST on, but now i would like to subtract 1 from that column unless it's value is already 1.

I can accomplish this using a hold file, but i would like to do this in the original procedure.
Hopefully it's a simple feature i'm overlooking.

EXAMPLE:

TABLE FILE CAR
SUM
CNT.DST.MODEL AS 'COUNT,DISTINCT,MODEL'
BY CAR
ON TABLE NOTOTAL
END

I need a column with CNT.DST.MODEL minus 1 if it's greater than 1.

Thanks ahead.

This message has been edited. Last edited by: Joe Beydoun,


version 8202M
Reporting Server on
Windows Server using DB2 Connect to access data from iseries.
 
Posts: 77 | Registered: December 29, 2009Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Is this what you want?

TABLE FILE CAR
SUM
COMPUTE MDL/I8 = CNT.DST.MODEL;
COMPUTE MLD/I8 = IF MDL GT 1 THEN MDL - 1 ELSE MDL;
BY CAR
ON TABLE NOTOTAL
END
 
Posts: 1903 | Location: San Antonio | Registered: February 28, 2005Reply With QuoteReport This Post
Gold member
posted Hide Post
Thanks a ton Prarie, I did the same earlier but as a decimal and it blew up, didn't realize it had to be integer.


version 8202M
Reporting Server on
Windows Server using DB2 Connect to access data from iseries.
 
Posts: 77 | Registered: December 29, 2009Reply With QuoteReport This Post
<JG>
posted
You can also use column notation

 TABLE FILE CAR
SUM 
   CNT.DST.MODEL
COMPUTE MLD/I8 = IF C2 GT 1 THEN C2 - 1 ELSE C2;
BY CAR
ON TABLE NOTOTAL
END 
 
Reply With QuoteReport This Post
Gold member
posted Hide Post
Sweet stuff JG, do you know of a good document with focus code? Some of this simple stuff i'm discovering could have save me a ton of time.


version 8202M
Reporting Server on
Windows Server using DB2 Connect to access data from iseries.
 
Posts: 77 | Registered: December 29, 2009Reply With QuoteReport This Post
Expert
posted Hide Post
This should be a bookmark in everyone's web browser: WebFOCUS Documentation - v7.6


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Count Feature

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