Commonly Used Formula Variables

Some examples of valid Formula lines follow:

DPRIN*.2:  Multiplies claim principal balance by 20%.

JMTAMT-JMTPAY:  Subtracts debtor payments received after judgment from the judgment amount.

ALLINT+NEWINT:  Adds all interest ever charged to claim and new interest thru today's date not yet added to claim balance together.

LDATED+10:  Adds 10 days to today's letter date.

JMTINTCHG+NEWINT:  Adds interest charged after judgment date and new interest thru today's date not yet added to claim together to arrive at total post-jmt interest amount.

DINT+NEWINT:  Adds current interest balance due and new interest thru today's date together.

ALLINT-JMTINTCHG: Subtracts interest charged after judgment date from all interest ever posted on claim to arrive at total pre-jmt interest charged.

PRINFEES + INTDUE:  Adds two user-defined formulas together.

LDATED - DOPENDT:  Subtracts claim open date from today's date to get number of days the claim has been open.

If(DENAMEL1[2]<>'', 'and',''):  Adds the word "and" if there is a codebtor. This formula can be modified to put an and between other fields such as the assigned debtors on a litigation item.

MaskLeft(XXXX,'X',6): Allows you to Mask/Hide Characters within an existing variable. XXXX = the Variable Name, 'X" = the character or symbol used for masking the characters and 6 = the number of characters that can be left unmasked. You can use 4 or 8 or 2.

Example for Reference Number(1234567890) Masking:

MaskLeft(REFNO, 'X',4) = XXXXXX7890;

MaskLeft(REFNO, '*', 6) = ****567890

MaskLFour(XXXX): Allows you to Mask/Hide all but the last 4 Characters within an existing variable. XXXX = the variable name.

Example for Reference Number (9876543210):

MaskLFour(REFNO) = xxxxxx3210

RightStr(XXXX,4): Allows you to get the last 4 characters of an existing variable. XXXX = the variable name and 6 = the number of characters to display.

Example for Reference Number (1234567890)

RightStr(REFNO,4) = 7890

RightStr(REFNO,8) = 34567890

LeftStr(XXXX,6): Allows you to get the first characters of an existing variable. XXXX = the variable name and 6 = the number of characters to display.

Example for Reference Number(1234567890)

LeftStr(REFNO,6)=123456

LeftStr(REFNO,3)= 123

See Account Member Variables: Adds new variables for newly added account member types.