that returns the cumulative interest paid on a loan between a start period and an end period in webfocus. Please help to solve this problem.i tried in many ways but no luck.This message has been edited. Last edited by: FP Mod Chuck,
Webfocus AppStudio 8201 Windows
January 28, 2019, 12:03 PM
Addy
Hi, Could you provide a sample code of what you are trying to do.
WF 8.2.04 Windows/Unix All Formats In Focus since 2006
January 28, 2019, 12:59 PM
Fernando
Durai, What you need to do is find out what the math is behind the CUMIPMT and implement that.
I have not looked at this in detail:
see [URL=http://pistulka.com/Other/?p=1678][/URL]
but the person claims that it contains the math behind it.
Fernando
Prod WF 8.1.04, QA WF 8.2.03, Dev WF 8.2.03
January 28, 2019, 11:11 PM
David Briars
Something like?...
-* File ExcelFunctionCUMIPMT.fex
SET PAGE = OFF
DEFINE FUNCTION CUMIPMT (P/D12.2, I/D12.2, N/D12.2, B/D12.2, E/D12.2, Q/D12.2)
-* Note:
-* Formulas from - https://www.wikihow.com/Calculate-Loan-Payments
-* - http://pistulka.com/Other/?p=1678
-* Input Parms:
-* Start Balance = P
-* APR = I
-* Cash Flows (Payments) = N
-* Payment Start = B
-* Payment End = E
-* Payments Per Year = Q
-* Step 1: Calculate the Payment.
M/D12.2 = P * ( (I/Q) / (1 - (1 + (I/Q))**-N));
-* Step 2: Calculate the Cumulative Interest Paid Between Two Periods.
CUMIPMT/D12.2 = (((P-M*Q/I)*(1+(I/Q))**(B-1)+M*Q/I)-((P-M*Q/I)*(1+(I/Q))**E+M*Q/I))-M*(E-B+1);
END
-*
DEFINE FILE CAR
CUMIPMTS/D12.2 = CUMIPMT(100000, .05, 48, 6, 7, 12);
END
-*
TABLE FILE CAR
"Example of finding Cumulative"
"Interest Paid Between Two Periods"
PRINT CAR
CUMIPMTS
IF RECORDLIMIT EQ 1
ON TABLE SET STYLE *
INCLUDE=jellybean_combo.sty, $
TYPE = TITLE, JUSTIFY=CENTER,$
ENDSTYLE
END
This message has been edited. Last edited by: David Briars,
January 29, 2019, 12:38 AM
Durai
Thanks so much for all.Problem solved with your HelpThis message has been edited. Last edited by: Durai,