Inserting numerical fields into a transaction description

You can insert your own fields into transaction descriptions, assigning them either constant values or values calculated by expressions.

Characters to use in expressions

The table below lists the characters that are valid in expressions used to define your own numerical fields.

Character	Meaning	Example
Arithmetic operators
+	Plus	FieldA + FieldB
-	Minus	FieldA - FieldB
:	Sum of fields from/to	FieldA : FieldC
*	Multiply	FieldA * 10
/	Divide (If both operands are integers, the result is an integer.)	FieldA / 2
%	Remainder	FieldA % 100 (returns the remainder of FieldA / 100)
Conditional operator
?	Does the field exist?	?FieldB (returns 1 if the field exists, otherwise 0)
Other characters used in expressions
( )	Parentheses	(FieldA+FieldB) * FieldC

Decimals are allowed in all expressions. However, make sure that the format of the transaction field allows for the maximum number of decimals that can result from the expression.

Rules for expressions

The maximum number of characters in an expression is 255.
Though in the expression you can refer to fields containing or receiving numerical values, you cannot refer to fields containing text.
Expressions in set transaction descriptions can only contain names of fields from the same occurrence of the same form (that is, the form referred to by Form name and Occurrence in the transaction field).
Do not use the equal sign (=) to assign a value to your own numerical fields. An equal sign assigns a default value to a transaction field.
The value assigned to this type of field, whether it is a constant or derived from an expression, must not have more than 15 significant digits or contain a decimal. Numbers with more than 15 digits are truncated.