To Use Arithmetic Operations

Arithmetic operations—such as Add<Operand1, Operand2>, Sub<Operand1, Operand2>, Mult<Operand1, Operand2>, Div<Operand1, Operand2>, Minus<Operand>, and Power<Operand1, Operand2>—are used primarily in attributes to calculate the value of a field from other fields. Arithmetic operations can also be used as operands in Where and OrderBy clauses in business query language (BQL) statements.

To Use Arithmetic Operations in Attributes

Compose the expression by using arithmetic operations. For example, you can calculate product reorder discrepancy by using the following BQL expression, where the decimal_0 constant represents the 0 decimal value. IsNull returns the first argument if it is not null or the second argument otherwise.
```
Minus<
    Sub<Sub<IsNull<Product.availQty, decimal_0>, 
            IsNull<Product.bookedQty, decimal_0>>, 
        Product.minAvailQty>>
```
Note: MYOB Acumatica Framework translates the previous BQL statement to the following SQL query.
```
 -((ISNULL(Product.AvailQty, .0) - ISNULL(Product.BookedQty, .0))
    - Product.MinAvailQty)
```

Use the calculated expression in an attribute (such as PXDBCalced) to define a calculated field that is not bound to a database column, as shown in the following sample code.

// Data field definition in a DAC
[PXDecimal(2)]
[PXDBCalced(typeof(Minus<
                       Sub<Sub<IsNull<Product.availQty, decimal_0>, 
                               IsNull<Product.bookedQty, decimal_0>>, 
                           Product.minAvailQty>>),
            typeof(Decimal))]
public virtual decimal? Discrepancy { get; set; }

To Use Arithmetic Operations in BQL Statements

Compose the expression by using arithmetic operations. For example, you can calculate product reorder discrepancy by using the following BQL expression, where the decimal_0 constant represents the 0 decimal value. IsNull returns the first argument if it is not null or the second argument otherwise.
```
Minus<
    Sub<Sub<IsNull<Product.availQty, decimal_0>, 
            IsNull<Product.bookedQty, decimal_0>>, 
        Product.minAvailQty>>
```
Note: MYOB Acumatica Framework translates the previous BQL statement to the following SQL query.
```
 -((ISNULL(Product.AvailQty, .0) - ISNULL(Product.BookedQty, .0))
    - Product.MinAvailQty)
```
Use the calculated expression in a BQL statement, as shown in the following example.
```
PXSelect<Product,
    Where<Minus<
              Sub<Sub<IsNull<Product.availQty, decimal_0>, 
                      IsNull<Product.bookedQty, decimal_0>>, 
                  Product.minAvailQty>>,
          NotEqual<decimal_0>>>
```
Note: MYOB Acumatica Framework translates the previous BQL statement to the following SQL query, where [list of columns] is the list of columns of the Product table.
```
SELECT [list of columns] FROM Product
WHERE -((ISNULL(Product.AvailQty, .0) - ISNULL(Product.BookedQty, .0))
        - Product.MinAvailQty) <> .0
```
MYOB Acumatica Framework explicitly enumerates the columns of the database table in the SQL query. For details on which columns are enumerated, see Translation of a BQL Command to SQL.