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]Use Count Records in Compute
Go
New
Search
Notify
Tools
Reply
  
[SOLVED]Use Count Records in Compute
 Login/Join
 
Platinum Member
posted
Scenario:

I have 3 equations to compute, Earned Premium %, Loss Ratio %, Frequency %. The first two are simple to compute, (Field 1 / Field 2) * 100. However, the last computation requires the COUNT of Field 1 / Field 2 *100. Is there any way to simply do this or is it as involved as it appears to be?

Here's what I've tried:
 TABLE FILE CAR
SUM 
     CNT.DST.CAR.BODY.SALES AS 'COUNT,DISTINCT,CAR.BODY.SALES'
     CAR.BODY.DEALER_COST
     COMPUTE Cost_By_Sales/D12.2 = CAR.BODY.DEALER_COST / CAR.BODY.SALES;
BY  LOWEST CAR.COMP.CAR
WHERE CAR.COMP.CAR EQ 'BMW';
ON TABLE SET PAGE-NUM NOLEAD 
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
END


Output:

Car: BMW
Sales: 5
Dealer Cost: 49,500
Cost_By_Sales: .62

What I would expect to see in Cost_by_Sales is 9,900(49,000/5).

This message has been edited. Last edited by: T.Peters,


WebFOCUS: 7702
O/S : Windows
Data Migrator: 7702
 
Posts: 127 | Location: San Antonio | Registered: May 29, 2009Reply With QuoteReport This Post
Guru
posted Hide Post
Try this instead.
quote:
TABLE FILE CAR
SUM
CNT.DST.CAR.BODY.SALES AS 'COUNT,DISTINCT,CAR.BODY.SALES'
CAR.BODY.DEALER_COST
COMPUTE Cost_By_Sales/D12.2 = CAR.BODY.DEALER_COST / CNT.DST.CAR.BODY.SALES;
BY LOWEST CAR.COMP.CAR
WHERE CAR.COMP.CAR EQ 'BMW';
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
END


WF 7.6.11
Oracle
WebSphere
Windows NT-5.2 x86 32bit
 
Posts: 398 | Registered: February 04, 2008Reply With QuoteReport This Post
Platinum Member
posted Hide Post
TABLE FILE CAR
SUM
CNT.DST.CAR.BODY.SALES AS 'COUNT,DISTINCT,CAR.BODY.SALES'
CAR.BODY.DEALER_COST
COMPUTE Cost_By_Sales/D12.2 = CAR.BODY.DEALER_COST / CNT.DST.CAR.BODY.SALES;
BY LOWEST CAR.COMP.CAR
WHERE CAR.COMP.CAR EQ 'BMW';
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
END


WF 8 version 8.2.01M. Windows.
In focus since 1990.
 
Posts: 188 | Location: pgh pa | Registered: October 06, 2004Reply With QuoteReport This Post
Platinum Member
posted Hide Post
Thanks guys. Thought I'd tried this, but guess not.


WebFOCUS: 7702
O/S : Windows
Data Migrator: 7702
 
Posts: 127 | Location: San Antonio | Registered: May 29, 2009Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED]Use Count Records in Compute

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