Related Information Examples & Tutorials
Want new features? Check out the news on the latest version of Collect! available. Members can download new enhancements FREE! Interested in new features available but not currently on a Membership? Please contact us for pricing. Enhancements may be purchased separately.
“ Hosted Collect! has saved us time, money, and worry on IT. We no longer have to concern ourselves with keeping a server up and running, replacing aging hardware, managing database backups and facilitating remote access for management/offsite employees. Maintaining a stable internet connection is all that is needed to keep our agents connected and productive. ” John Y.

How To Use Math With Database Fields

You can use math in reports or letters when printing database information. For example, you could use @(de.ow-de.fe) or @(de.ow/3) or @(de.pr+de.fe).

Parentheses () are supported, enabling you to build complex equations. Notice that in these equations, as illustrated above, math functions start with the @ and contain NO SPACES. Field identifiers are entered WITHOUT the @ sign.

EXAMPLES:

@(de.pr+de.fe)

This function Adds (+) the debtor's Principal and Fees.

@(tr.tu+tr.di)

This function Adds (+) the "To Us" and "Direct" amounts recorded in a transaction. The result is a total transaction amount, regardless of being paid to the agency or directly to the Client.

@(de.ow*0.015)

This function Multiplies (*) a debtor's Owing times 1.5% interest to print the current interest charges.

@(de.ow/3)

This function divides (/) the debtor's Owing by three. Be sure the division operator slants in the right direction!

Printing math calculations based on database fields is covered further in How To topics addressing the use of Lists and Loops, Conditional Expressions, Variables and Totals. These are advanced topics and should only be attempted if you are able to produce basic reports that consistently output data correctly.

If you find that these concepts are more complicated than your design time allows, the Collect! support team can produce quality custom reports for you. See How To Order Custom Reports.

See Also

- Report Sample to view sample reports and letters
- Report Topics Index for a list of all report and letter topics

Top of page.

Was this page helpful? Do you have any comments on this document? Can we make it better? If so how may we improve this page.

Please click this link to send us your comments: helpinfo@collect.org

Collection Advisor Veracode Verified RMA ACA Member