Skip to main content
Skip table of contents

Create a Comparison Field

A comparison field compares two existing fields. It creates three field values:

  • Field A is less than Field B
  • Field A is equal to Field B
  • Field A is greater than Field B

The fields being compared must be at the same hierarchical level.

For example, if you create a comparison between Account Profit and Average Account Balance the UDF will provide the following values:

  • Account Profit is less than Average Account Balance
  • Account Profit is equal to Average Account Balance
  • Account Profit is greater than Average Account Balance

To create a comparison field:

  1. Select Cross > Define Field. The Define Fields window displays.
  2. Click Comparison. The Comparison Field window displays.
  3. Enter the following details:

    FieldDescription
    Field NameEnter a name for the field.
    CompareSelect the first field for the comparison.
    WithSelect the second field for the comparison.
  4. Click OK.
JavaScript errors detected

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

If this problem persists, please contact our support.