Skip to end of metadata
Go to start of metadata

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:

    Field NameEnter a name for the field.
    CompareSelect the first field for the comparison.
    WithSelect the second field for the comparison.
  4. Click OK.
  • No labels