Thanks for both replies. Good ideas. I think testing for a minimum term will work, for now. One of those things I should have done right away...
I'll also check into getting a user function compiled. We are a financial institution and would use such a function often.
Thanks for the reply. I didn't put the complete version of the formula in my original post, sorry. I am already doing the checking you describe, making sure there are no nulls or zeros. Those don't seem to be causing the problem. Here's an example that does generate the numeric overflow...
I have a simple formula that uses the Nper function to calc the remaining term (in months) on a database of several hundred commercial loans. The intent is to compare the results of the Nper formula to the actual source system data values and isolate loans with improper interest rates, payment...
We recently upgraded to CE9. Users who do not have access to ePortfolio have the Crystal Offline Viewer installed on their desktops. They view reports either by clicking on a link through our intranet, or double clicking on the .rpt file in Windows Explorer.
Here's the problem: Section...
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.