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,
all output (Excel, HTML, PDF)
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:
open_balance * (((stop-date - begin-date) * (percent / 100)) / 365)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".
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
If the report output is destined for Excel, you might be able to use an Excel template to perform the calculation.
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.
Don't know if RSTAT has it though.
|Powered by Social Strata|