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] NPER Excel formula Implementation Needed
Go
New
Search
Notify
Tools
Reply
  
[Solved] NPER Excel formula Implementation Needed
 Login/Join
 
Gold member
posted
NPER(Rate, PMT, Pv, Fv, Type) calculates the number of periods required to pay off a loan for a constant periodic payment and a constant interest rate.I Found this formula in Excel and need to implement this in Webfocus.Pls any one help me to solve this?

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


Webfocus AppStudio 8201
Windows
 
Posts: 52 | Registered: May 09, 2016Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Here's an example of a WebFOCUS function for a different calculation you could follow to write the NPER function yourself.
http://forums.informationbuild...417070196#3417070196

That's how I came up with the code below which calculates Periods in a function using the formula from this site: https://help.anaplan.com/anape...ctions/All/NPER.html.
  
SET PAGE = OFF
DEFINE FUNCTION NPER (P/D12.2, F/D12.2, PMT/D12.2, R/D12.2, T/I1)
-* Note: 
-*  LOG((-R*F+PMT*(1+Rate*Type))/(Rate*Pv+PMT*(1+Rate*Type)))/LOG(1+Rate)  
-*  Input Parms:
-*  Present Value         = P
-*  Future Value          = F
-*  Payment             =PMT
-*  Interest              = R
-*  Type                  =T

NPER/D12.2 = LOG((-R*F+PMT*(1+R*T)) / (R * P+PMT*(1+R*T)))/LOG(1+R);
END
-*
DEFINE FILE CAR
PERIODS/D12.2 = NPER(-10487,4000,300,.0040,0);
END
-*
TABLE FILE CAR
"Example of NPER"
"Number of Periods"
PRINT 
      PERIODS
BY COUNTRY

ON TABLE SET STYLE *
ENDSTYLE
END

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


WebFOCUS 8206, Unix, Windows
 
Posts: 1675 | Location: New York City | Registered: December 30, 2015Reply With QuoteReport This Post
Gold member
posted Hide Post
Thank you so much BabakNYC. I solved my problem with your Help


Webfocus AppStudio 8201
Windows
 
Posts: 52 | 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] NPER Excel formula Implementation Needed

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