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.