

Go  New  Search  Notify  Tools  Reply 
Gold member 
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  

Virtuoso 
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 ENDThis message has been edited. Last edited by: BabakNYC, WebFOCUS 8204, Unix, Windows  

Gold member 
Thank you so much BabakNYC. I solved my problem with your Help Webfocus AppStudio 8201 Windows  

Powered by Social Strata 
Please Wait. Your request is being processed... 