Open topic with navigation

Create a Numeric Lookup Field

Home | FAQs & Troubleshooting

 

Expand/Collapse all Show/Hide All

Expand/Collapse item  Overview

You can create numeric fields to add to the Selected Columns list box in the second Lookup Customization Wizard page. Numeric fields are created by combining two or more fields together using arithmetic operators. For more information, see Lookup Customization Wizard.

 

To create a numeric lookup field

  1. In the second Lookup Customization Wizard page, click New Field to create a new numeric field using simple arithmetic functions.

  2. In the Lookup Customization Wizard - New Field window, in the Heading field, type the name for the column/field.

  3. Type the width, and select the justification.

  4. Type the mask.

  5. Click the Calculated Field button to enter simple arithmetic calculations.

  6. In the Calculated Field Builder window, double-click a field in the Available Fields list. This moves the field to the expression area. Select an operator, choose another field from the list, and click OK.

  7. In the Lookup Customization Wizard - New Field window, click OK. The newly created field automatically appears as a column in the Selected Columns list box.

© Sage Group plc 2019. Privacy Policy | Copyright/Trademarks