Hi,
Did anyone deal with IRR calculations?
We have IRR function with in WebFOCUS but we cannot use it in infoassist environment.
Is there anyway to do it manually with computes?

Thank you.

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

Please define, or elaborate on, what "IRR" is and what you need from it.
"Internal Rate of Return", right?

COMPUTE would be my first guess...

Some FocalPoint posts on "Internal Rate of Return" are here.

Hi Doug,
Yes, I need internal rate of return calculation in info assist environment.
Problem is internal rate of return needs looping through the calculation and looping does not work in infoassist.
I can design a standard report but the user does not want a standard report because they would loose the adhoc reporting functionality.
I am trying to convince the user to take the standard report approach.

Construct a report that does the looping to get your calculation and finish with an ON TABLE PCHOLD. Then deploy the report as a WFRS web service. You can then map the WFRS web service back to WF and deploy as a synonym. Have IA go against that synonym.

Unfortunately, that method would not work for me because IRR calculations are based on the filters and sorts that the users select. In other words, IRR have to be calculated on the fly based on the data that would be returned.

Thank you.

Opened a case with IBI on this. They asked us to submit IRR for infoassist as a new feature request.