|
| | | Junior Member
 
Group: Forum Members
Last Login: 5/8/2008 10:41:52 AM
Posts: 17, Visits: 91 |
| What about when one of the entries in the formula is blank?
For example, I'm trying to do this:
(loan origination fee + loan discount fee + mortgage broker fee)/loan amount x 100
the resulting formula being
{=PNT_1023 + PNT_1024 + PNT_1026/PNT_11*100}
But it works only when all the fields have a value. If, say, the loan discount fee is blank, a syntax error is generated.
I tried an if-then-else so a "0" would be inserted if the field were blank, but it doesn't work either.
Incidentally, if I use a table and SUM(ABOVE), the formula ignores anything above the blank cell. In this case, if I stack 1023, 1024, and 1026, and 1024 is blank, only 1026 is used in the formula.
Is there an easy fix? Thanks... |
| |
| | | 
Supreme Being
Group: Forum Members
Last Login: 12/16/2008 1:31:52 PM
Posts: 124, Visits: 970 |
| | try a variation of this formula that I use to calculate a group of fees that may have 0s. {={if {mergefield pnt_5308}=”” “0.00” “{mergefield pnt_5308}”}±{if {mergefield pnt_5309}=”” “0.00” “{mergefield ont_5309”} This is a very basic one that will add 2 fields even if one has a 0 amt.
"MMM Yeah, I'm going to need you to go ahead and come in on Saturday." |
| |
| | | Supreme Being
Group: Forum Members
Last Login: 10/8/2008 8:13:28 PM
Posts: 126, Visits: 152 |
| MBSMortgage (10/21/2005)
I'm trying to use mergecodes in a formula. The formula I'm using looks something like this: {= <<pnt_753>>+<<pnt_754>>+<<pnt_755>>} This works fine and displays the sum of those 3 fields, however when I'm editing the custom form it displays: !Syntax Error, < I'm wondering if there is a problem with my formula. Obviously not a bad enough problem to stop it from working but enough to get that error. I'm guessing that it's because there isn't any data being put into the formula in edit mode so it's screwing up the syntax. Anyone have any suggestions for using formulas like that? The syntax error code is telling you that you have an "is less than" function ( < ) in a place it shouldn't be. This is because your field ID's come in the form "<<Field ID ____>>." When Point prints the form, it first replaces the <<Field ID ____>> with the actual value, which eliminates the syntax error. The only way to tweak the form and see the result is to keep printing it. You can save paper by printing to PDF. Regards, Edit: removed accidental emoticon. changed (< to ( < ) |
| |
|
|