In these fields, you can enter calculation formulas for the variables defined in the window Specification of Output Data Formats for the current format. The number refers to the variable with the corresponding number in the window Specification of Output Data Formats; variable 1 = variable 1, variable 2 = variable 2, and so on.
The variable operation takes place every time the current record is written to the file. In the table part of this window, you can enter more variable operations to be performed for each field in the current record when it is written to the file.
As an example of a calculation, you can increase the variable specifying the total number of entries by one for each payment record. If it is specified in the window Specification of Output Data Formats that variable 3 is of the type “Integer Field,” you can specify the following in field no. 3 in this island:
#VARIABLE.3 + 1
This assigns the value of variable 3 plus 1 to variable 3.
If variable 5 has been specified as having the type “Amount Field,” you can specify the following in field no. 5 in this island:
#VARIABLE.5 + #PAYMENTLINE.PAYMENTCURRENCY
This means that variable 5 is assigned the value of variable 5 plus the amount from the current payment record. In this way, the total payment is summed up, so it can be written, for example, in the end record of the payment file.
You can also refer to the special variable #VARIABLE.0, which contains the value currently being written to the payment file.
“Appendix D: Reference Fields in Format Specifications” in the Reference Manual contains a list of all the fields to which you can refer.
You can use the following expression operators:
+ | - | > | < | = | >= | <= | <> | * | / | %
On a Macintosh, the operators >=, <=, and <> can also be written like this:
Š | ð | ¦
The operator / means division and returns a real number, also when dividing two integers. The operator % returns a percentage
– #VARIABLE3 % VARIABLE4 thus shows variable 3 less variable 4,
divided by variable 4 and multiplied by 100. If variable 4 is 0, the result will also be 0.
|