Calyx Software Message Board / Calyx Point / Custom Forms / Worst Case Payment and Rate / Latest Posts

RE: Worst Case Payment and Rate

sb1920alk — Fri, 13 Jun 2008 15:35:56 GMT

[quote][b]BetaFisch (9/12/2007)[/b][hr]There are no fields for that data currently in Point.[/quote]

How about now?

RE: Worst Case Payment and Rate

tennell — Thu, 20 Sep 2007 10:34:34 GMT

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.

RE: Worst Case Payment and Rate

BetaFisch — Wed, 12 Sep 2007 06:34:39 GMT

There are no fields for that data currently in Point.

Worst Case Payment and Rate

sb1920alk — Tue, 11 Sep 2007 16:50:29 GMT

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,