Performing Calculations

Simple calculation

To perform a simple calculation set mapping type to calculation and type constant or formula into calculation edit box

Multiplying fields

StrToFloat([INTEGER_F]) * StrToFloat([FLOAT_F])

Concatenation

[INTEGER_F]+ kilos"

More complicated examples

Iif(StrToFloat([FLOAT_F])> StrToFloat([INTEGER_F]),1,2)
Trim('[CHAR_F]')

The good starting point is an Expression Editor.

More information about scripting language

• Date formats
• Scripting Language
• Best practice for calculations