|
| | | Supreme Being
Group: Forum Members
Last Login: 10/8/2008 8:13:28 PM
Posts: 126, Visits: 152 |
| | Is there a field ID I can reference for the worst case payment and worst case rate? I can use Word's math functions to add the note rate and life cap if I have to, but it would be easier to reference the actual field if there is one. To clarify, this is not the same as the max rate the TIL calculates, which is based on the current index and margin. Thanks, |
| |
| | | 
Sepal
Group: Moderators
Last Login: Yesterday @ 4:30:31 PM
Posts: 1,178, Visits: 9,169 |
| There are no fields for that data currently in Point.
Disclaimer: This post carries no explicit or implied warranty. Nor is there any guarantee that the information contained in this post is accurate. It is offered in the hopes of helping others, but you use it at your own risk. The author will not be liable for any damages that occur as a result of using this post.  |
| |
| | | Forum Newbie
Group: Forum Members
Last Login: 2/3/2008 8:04:54 AM
Posts: 4, Visits: 86 |
| | I created one to calculate the lifetime cap. For example if the start rate is 5.5 and the lifetime cap is 6 then the lifetime cap rate on the form would read (11.5). Below is the Formula. By the way Field Id 12 is the Note Rate and Field Id 2325 is the lifetime cap. {={if {MERGEFIELD PNT_12}="" "0.00" "{MERGEFIELD PNT_12}"}+{If {MERGEFIELD PNT_2325}="" "0.00" "{MERGEFIELD PNT_2325}"}} NOTES: 1) Where you see the BOLDED { you must press the CTRL+F9 key to get it. Hitting the { } keys on your keyboard will not work. 2) Where you see the MERGEFIELD PNT, you must use the point custome form dialog box to insert the field. For example to MERGEFIELD PNT_12, go to the Point Custom Form, Click the drop down box, highlight note rate and click insert. 3) If at any time you receive an error while typing the formula, Highlight the grey box, right click, then left click on Toggle Field. This will bring the formula back up and you can continue typing. 4) Look at your typing carefully. If you have an extra bracket or any other typo in the formula, it will not work. Remember your middle school math class, you must have a close parentheses for every open parentheses. Hope this helps.
Scott Tennell
Continental Capital Funding
Florida |
| |
| | | Supreme Being
Group: Forum Members
Last Login: 10/8/2008 8:13:28 PM
Posts: 126, Visits: 152 |
| BetaFisch (9/12/2007)
There are no fields for that data currently in Point.How about now? |
| |
|
|