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] CUMIPMT formula implementation Needed
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] CUMIPMT formula implementation Needed
 Login/Join
 
Gold member
posted
I need to implement the Excel formula

=CUMIPMT(rate, nper, pv, start_period, end_period, type)

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
 
Posts: 49 | Registered: May 09, 2016Reply With QuoteReport This Post
Gold member
posted Hide Post
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
 
Posts: 74 | Location: UK | Registered: September 17, 2018Reply With QuoteReport This Post
Guru
posted Hide Post
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
 
Posts: 259 | Registered: October 10, 2006Reply With QuoteReport This Post
Master
posted Hide Post
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,
 
Posts: 754 | Registered: April 23, 2003Reply With QuoteReport This Post
Gold member
posted Hide Post
Thanks so much for all.Problem solved with your Help

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


Webfocus AppStudio 8201
Windows
 
Posts: 49 | Registered: May 09, 2016Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] CUMIPMT formula implementation Needed

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