# DataMgr 2.5 Documentation: Math

## DataMgr Information

API Documentation

XML Schema

Demonstration Site

Blog Entries

DataMgr CFC Docs Subscribe to DataMgr Email: Visit this group

## Math

The "math" relation allows you to perform basic mathematical operations between two fields from within DataMgr. The operators allows are: +-*/, for addition, subtraction, multiplication, and division respectively.

### Attributes/Keys:

• type (required): "math".
• field1 (required): A field in the same table as the relation field (or a numeric value).
• field2 (required): A field in the same table as the relation field (or a numeric value).
• operator (required): The operation to be performed (among: +-*/,).

Among the uses for this is the ability to calculate an order total in a cart. Each line item could have a total cost that is a multiplication of the quantity by price. The order itself could then add these values for the pre-tax total and take that number and multiply it by the tax rate (pulled from another relation field). All of this could now be done from within DataMgr without writing any SQL.

### Example (XML):

``````<field ColumnName="MyField">
<relation type="math" field1="OrderTotal" field2="TaxRate" operator="*" />
</field>``````

### Example (setColumn):

``````cfset sRelation = StructNew()>
<cfset sRelation.type = "math">
<cfset sRelation.field1= "OrderTotal">
<cfset sRelation.field2= "TaxRate">
<cfset sRelation.operator= "*">
<cfset Application.DataMgr.setColumn(tablename="MyTable",ColumnName="MyField",Relation=sRelation)>``````