I was wondering if anyone knows of a way in WebFOCUS to do a present value calculation? I have yet to find anything related financial calculations, anywhere.This message has been edited. Last edited by: Kerry,
WebFOCUS 7.1.6 Windows all output (Excel, HTML, PDF)
March 02, 2010, 03:01 PM
Francis Mariani
I used a Google Search for "present value" at Information Builders and got one hit - a PDF document explaining how to call "Subroutines Written in REXX". The present value example in this function includes this calculation:
If this is your kind of present value, perhaps it could be done in a compute, or you could DEFINE a FUNCTION by "Creating Temporary Fields Unrelated to Master Files".
Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
March 02, 2010, 03:07 PM
Dan Satchell
If the report output is destined for Excel, you might be able to use an Excel template to perform the calculation.
WebFOCUS 7.7.05
March 02, 2010, 03:43 PM
Waz
As Franscis said, get the formula and perhaps build a DEFINE FUCNTION.
I had a quick look on the internet, and found this at wikipedia, it may help.