Focal Point
[SOLVED]Use Count Records in Compute

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/2187015695

January 06, 2011, 01:40 PM
T.Peters
[SOLVED]Use Count Records in Compute
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
January 06, 2011, 02:53 PM
RSquared
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
January 06, 2011, 02:54 PM
Spence
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.04. Windows.
In focus since 1990.
January 06, 2011, 03:33 PM
T.Peters
Thanks guys. Thought I'd tried this, but guess not.


WebFOCUS: 7702
O/S : Windows
Data Migrator: 7702