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
|
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