NP Function – Overview and Its Usage


NP Function:

=NP (What, Arg1, Arg2, …,Arg22)

Purpose:  Performs utility operations on data to be used in other Jet functions.

NP Function helps you to perform certain utility tasks such as creating a list of dates for a certain time period, performing union and intersection of arrays, or evaluating a function/formula.

NP Function

Function Reference

NP function is one of many Jet functions like NFNL and GL etc. Below is its function reference:


  • “Codeunit” (Dynamics NAV only)
    Returns a value from a NAV codeunit running on the NAV web service. This requires Windows Authentication while connecting to the database through NAV Web Services or other connection types (SQL Direct, C/Front, JRDS).
  • “Companies”
    Retrieves a list of all the companies that match the company filter for the specified data source.
  • “Datasources”
    Returns list of all the data sources created by the user.
  • “DateFilter”
    Constructs a date range for use as a filter in the NP Function. It uses the start date and end date specified in the Arg1 and Arg2 parameters.
  • “Dates” 
    Returns a string that can be used to generate dates using a Replicator, where: 
    1) Arg1 is the start date
    2) Arg2 is the end date
    3) Arg3 allows to select period type such as Day, Week, Month etc.
    4) Arg4 returns the end of each period if set to “True”. Default is “False”.
  • “Eval”
    Used to evaluate a formula in the NP Function. The formula must be enclosed in quotes and is evaluated when the report refreshes.
  • “Format”
    Formats an expression with a specific Excel formatting string. Arg1 is the expression to format such as a date or cell reference, and Arg2 is the Excel formatting string such as “YYYY/MM/DD” for a date formatted with a 4-digit year then a 2-digit month and 2-digit day.
  • “Formula”
    Evaluates the Excel formula contained within Arg1.
  • “Integers”
    Retrieves a list of integers for the specified start and end numbers.
  • “Join”
    Joins a list of items by the specified character sequence and returns a string.
  • “Language”
    Returns the currently loaded language module using the NP Function.
  • “Slicer”
    Converts an Excel Slicer to a filter that can be used in Jet functions. The Excel Slicer referenced by the NP(Slicer) function must be associated with at least one pivot table in order for the NP(Slicer) function to update properly.
  • “Split”
    Splits a string on the specified character sequence and returns a string using the NP Function.
  • “Union”
    Calculates the union of the specified set of arrays. The arrays are specified in the Arg1 and Arg2 parameters.

If You Need Any Help, Contact us Now!

Scroll to Top