[CLOSED] Is it possible......

Greetings All!

I'm new to Webfocus, and could really use your help. I'm creating a report where I have to calculate a consolidated interest rate- which I was finally able to do after using a series of RECAP statements where I calculate the weighted avg then round to the nearest .125

Loan A 18,000 6.8
Loan B 20,000 5.0
___________________________
38,000
**RECAP1 5.852
**RECAP2 47
**RECAP3 5.875

I need to be able to somehow store and use the RECAP 3 value in another report that will take the total (38k) and calculate monthly payment, total loan cost- etc using RECAP 3 as the interest rate.

Any help is INCREDIBLY appreciated.

Cheers.

Is this possible?

This message has been edited. Last edited by: Kerry,

7.69/Windows/HTML or Excel

Posts: 2 | Location: United States | Registered: April 26, 2011

Alan B

Virtuoso

posted

Hide Post

Use POST, as in:


FILEDEF OUT DISK BASEAPP/OUT.DAT
DEFINE FILE CAR
CUR_YR/I5C=DEALER_COST;
LAST_YR/I5C=.87*CUR_YR - 142;
END
TABLE FILE CAR
SUM CUR_YR LAST_YR
FOR COUNTRY  
ENGLAND LABEL AR POST TO OUT OVER 
FRANCE LABEL INV POST TO OUT OVER
RECAP TOTCASH/I5C = R1 + R2; POST TO OUT AS 'TOTAL CASH' 
END

Then follow with PICKUP

Alan.
WF 7.705/8.007

Posts: 1451 | Location: Portugal | Registered: February 07, 2007

Ignored post by Alan B posted

Show Post

FrankDutch

Virtuoso

posted

Hide Post

please post your code so we can see how you calculated the weighter average.

if you write the result to a hold file you can use it in at an other place

	*Frank*
	prod: WF 7.6.10 platform Windows, databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7 test: WF 7.6.10 on the same platform and databases,IE7

Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006

Ignored post by FrankDutch posted

Show Post

pmck

Member

posted

Hide Post

Thanks for the responses! Here's my code...
I'm so sorry if it's bad- I'm using the GUI.

The variable I really need to reference in my new report is STDCONSOL

When I make a new report- how do I reference and use it?

TABLE FILE FA

SUM
COMPUTE interestrate/D12.2% = IF ITYFA_LOAN_PROGRAM EQ 'P' THEN 5.00 ELSE 6.80;
AS 'Interest ,Rate'
'STAWD_ACCEPT_AMOUNT/D20CM'
AS 'Total Principal Borrowed'
COMPUTE CONSOLTOP/D12.2 = ( interestrate / 100 ) * STAWD_ACCEPT_AMOUNT; NOPRINT
BY 'FA_STDNT_AWARDS_DIM.FA_STDNT_AWARDS_DIM.STAWD_EMPLID' NOPRINT
BY ITYFA_LOAN_PROGRAM_LDESC AS 'Loan Program'
BY ITYFA_ITEM_TYPE_LDESC AS 'Loan Type'

ON FA_STDNT_AWARDS_DIM.STAWD_EMPLID RECAP
WGTAVG/D12.3 = ( CONSOLTOP / STAWD_ACCEPT_AMOUNT ) * 100;
ON STAWD_EMPLID RECAP
NOROUND1/P12 = ( ( CONSOLTOP / STAWD_ACCEPT_AMOUNT ) * 100 ) * 8;
ON STAWD_EMPLID RECAP
FINALRT/D12.3 = NOROUND1 / 8;
ON STAWD_EMPLID RECAP
STDCONSOL/D12CM = ( STAWD_ACCEPT_AMOUNT * FINALRT ) + STAWD_ACCEPT_AMOUNT; <<<<<<<<<<

7.69/Windows/HTML or Excel

Posts: 2 | Location: United States | Registered: April 26, 2011

Ignored post by pmck posted

Show Post

dhagen

Virtuoso

posted

Hide Post

Lookup the function PUTDDREC. That will write out the value to a file, then you can read it in as a param and use it in downstream reports.

"There is no limit to what you can achieve ... if you don’t care who gets the credit." Roger Abbott

Posts: 1102 | Location: Toronto, Ontario | Registered: May 26, 2004

Ignored post by dhagen posted

Show Post