Multi Calc
Overview
The Multi Calc macro performs the same calculation across up to ten fields at once. It is easier than copying and pasting an expression across multiple lines of a Calculate tool.
Multi Calc macro configuration parameters
The Multi Calc macro has a single set of configuration parameters.
Parameter | Description |
---|---|
Expression | Expression to calculate. Use any combination of mathematical operations and functions that is appropriate for your field data.
|
F0...F9 | Fields on which the Expression will be evaluated. You may specify up to 10 fields.
|
Configure the Multi Calc macro
Select the Multi Calc icon.
Go to the Configuration tab on the Properties pane.
Select Expression and enter the expression to be evaluated. To use the field(s) being operated on as a part of the expression, use the placeholder $IN.
Select up to ten fields in the f0...f9 boxes. For example, to covert the three fields ADDRESS1, ADDRESS2, and LASTLINE into lowercase, configure the following properties.
Optionally, go to the Execution tab, and then set Web service options.