|
| | | 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: 2 days ago @ 1:30:00 PM
Posts: 1,504, Visits: 12,111 |
| 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.  |
| |
| | | Junior Member
Group: Forum Members
Last Login: 1/14/2010 10:44:31 PM
Posts: 23, Visits: 107 |
| | 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? |
| |
| | | Junior Member
Group: Forum Members
Last Login: 11/1/2009 2:58:55 PM
Posts: 17, Visits: 33 |
| | 'Tennell' you are the best! THANK YOU SO MUCH! the learning curve was steep. but I've figured out what you shared and it WORKS!  I'm actually using this method with more advanced math too. |
| |
| | | 
Supreme Being
Group: Forum Members
Last Login: 2 days ago @ 11:06:56 AM
Posts: 265, Visits: 609 |
| Anyone know if this will work in Word 2007? I can't get it to ...
Thank you,Eric J. Lilly |
| |
| | | Supreme Being
Group: Forum Members
Last Login: 6/25/2010 4:41:09 PM
Posts: 153, Visits: 378 |
| Yes, this does work in Word 2007. I've done it with simple math problems only and it felt like it took me forever to get it to work right. When it's working correctly, you'll actually see a $!Syntax Error, <. That threw me completely off and had me working on it for a couple of hours, not realizing it was working right and all I had to do was actually generate the form.
Danielle PlummerArbor Mortgage |
| |
| | |
Supreme Being
Group: Forum Members
Last Login: 2 days ago @ 11:06:56 AM
Posts: 265, Visits: 609 |
| Is anyone able to see what I am doing wrong with my formula? You chnge the file extension to .pcd to view in Point. I just took one of our forms and put the formula at the top as an example.
Thank you,Eric J. Lilly
|
| |
| | |
Supreme Being
Group: Forum Members
Last Login: 2 days ago @ 11:06:56 AM
Posts: 265, Visits: 609 |
| Figured it out - duh. Should be using the * character and not the X character.
Thank you,Eric J. Lilly |
| |
|
|