How to Use NL ("First") Function to Display the First Value in a Table
NL ("First") is a powerful Jet function that returns the first result found, only the first result. It can be used to extract the first value from any table. In this tutorial, we will use NL ("First") to show the first customer number in Excel.
Open your Excel report and navigate to the Jet tab.
Click on the "Tools" button and select the NL function from the drop-down menu.
3. In the pop-up window, fill in the following details:
"First" in the "What" tab.
"Customer" in the "Table" tab.
"No" in the "Field" tab.
4. Click on "OK".
5. Give the column a name in cell D4.
6. Run the report to see the first customer number.
NL ("First") is a great tool for quickly retrieving the first value in a table. By following this tutorial, you should now be able to use the NL ("First") function to display the first customer number in Excel.