Related Information Examples & Tutorials

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.

See Also

- How To Calculate Date Ranges in Reports and Letters
- How To Use Math with Database Fields
- How To Use Date Ranges in Complex Reports
- 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