Related Information Examples & Tutorials
 “ Collect! is the software we used to start our debt collections business in 1999 ... now we are using about 100 licenses. ” Ken W.

## How To Use Arithmetic Operators

The four basic arithmetic operators [+, -, *, /} are used in reports. These can be combined with the equals [=] operator as shown below.

The following operators are used for the functions listed:

 + Add Example: @(de.in+de.fe) Adds the debtor interest and fees together. += Add To Value Example: @tvarCnt += 1 Increments a counter by one. - Subtract Example: @(de.ow-de.fe) Subtracts the debtor's fees from the owing. -= Subtract From Value Example: @tvarCnt -= 1 Decrements a counter by one. * Multiply Example: @(de.ow*0.10) Multiplies the debtor's owing by 10% *= Multiply Value Example: @tvarTotal *= 0.10 Multiplies the value of tvarTotal by 10% / Divide Example: @(de.ow/12) Divides the debtor's owning by 12. /= Divide Value Example: @tvarTotal /= 12 Divides the value of tvarTotal by 12.

Arithmetic operators are used in many areas of report and letter design.

How To Calculate Date Ranges in Reports and Letters shows how these operators are used to print dates in the past or future. You can use mathematically derived dates in many other ways as well. See How To Use Date Ranges in Complex Reports for more information.

Many fields in your database contain numeric data. Arithmetic operators can be used to create functions using these fields. Calculations based on this data can be printed in your report. Refer to How To Use Math with Database Fields.

Time fields can be added or subtracted in reports by using arithmetic operators.

Date fields can be added or subtracted in reports by using arithmetic operators.

There are many other uses of math operations in report generation. For instance, when using Lists and Loops, Totals can be calculated for numeric data fields. Refer to How To topics on Lists and Loops, Conditional Expressions, Variables and Totals for information regarded advanced topics in the use of math operations.

Remember to review the list of pre-defined reports for templates that you can use. Collect!'s support team can design custom reports for you. Refer to How To Order Custom Reports. As well, there is an extensive list of report samples that you can view and choose from. Refer to Report Sample for this.    