Skip to main content
Skip table of contents

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.

  • Default: blank

F0...F9

Fields on which the Expression will be evaluated. You may specify up to 10 fields.

  • Default: blank

Configure the Multi Calc macro

  1. Select the Multi Calc icon.

  2. Go to the Configuration tab on the Properties pane.

  3. 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.

  4. 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.

    image-20240402-144853.png

  5. Optionally, go to the Execution tab, and then set Web service options.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.