Chief,
Thank you so much for your response. I'm still figuring this out now but before that is it even possible to simply register this Excel library which includes this XIRR within SQL 7.0 OLAP services and use it as an external MDX function? Do I have to use Access for this?
Thanks again,
GG
It seems difficult to write SQL for the calculation of XIRR which is a financial function that measures the internal rate of return for cash flows over a period of time. Microsoft Excel has this function (XIRR). Could I maybe use this Excel function (use its library) from within my SQL OLAP...
Hi,
I'm wondering if there was any resolution for this XIRR calculation in SQL because I need this now as well. If someone could get back to me with suggestions I would be obliged.
Thanks
Gopal
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.