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.