Lesson 6: Create a Defined Field (GL Natural Segment) Create a New Report Right-click on the Expense Analysis (Line Item/Export) object and select NEW > REPORT. Add the following column to the report as dimensions (BY): Header (Segment) - LineItem (Segment) - LineItem_Matter (Segment) - AuditExport (Segment) - GLACCOUNT (Field) Open Define Calculation In the Data tab, within the Calculation group, select Detail (Define). In the Detail Field (DEFINE) pop-up window, click on the fx button in the top right corner to display the function list. Expand the Character Legacy folder. Double-click on the SUBSTR function. Define the Substring Function We want to extract the first four characters from the GL Account number. Name the Field Natural. For the SUBSTR function: Change the length to 10 (or the maximum length of the field). Click on the Tree View button. Change the string to Header (Segment) - LineItem (Segment) - LineItem_Matter (Segment) - AuditExport (Segment) - GLACCOUNT (Field). Change start to 1 (the character position that we begin the extraction from). Change end to 4 (the final character position that we are extracting). Change the sublen to 4 (the length of the string). A larger value will result in spaces being added. Change the output_format to Natural (i.e., the name that you determined for the field). The final function should be: SUBSTR ( 10, HEADERLINEEXPORT.AuditExport.GLACCOUNT , 1 , 4 , 4 , Natural) Change the Field Format Click on the Format button. Change the Field type to Alphanumeric. Change the Total length to 4. Click OK in the Field Format Options for (Natural) window. Click OK in the Detail Field (DEFINE) window. New "Natural" Field and Handling Errors You should find the new Natural field at the bottom of the AuditExport segment. If the field is not there, scroll to the bottom of all the tables and look there. You can right-click on the Natural field and select Edit if you need to make any changes. If you receive the following Internet Explorer dialogue box, click NO. You may have to answer no more than once. InfoAssist runs lengthy JavaScripts that sometimes generate this question. Add Additional Fields to Report Add the new Natural field to the left of the GLAccount field in the Interactive Design View pane. Add Header (Segment) - LineItem (Segment) - LineItem_Matter (Segment) - AuditExport (Segment) - AMOUNTSPENTAPPROVED (field) as a measure. Add Header (Segment) - LineItem (Segment) – LineItemType (Segment) - Expense (field) as a dimension. Subtotal by the Natural field. Save the Report In the Quick Access Toolbar, click the Save button. Save the report in this location Content > [Your Company Name] > My Content. Name the report “Lesson 6 – Creating a Defined Field (GL Natural Segment)." Exit InfoAssist. Was this article helpful? Yes No