NF Function – Overview and its Usage

Overview of NF Function

NF Function

=NF (Key,Field,FlowFilterField1,FlowFilter1,…,FlowFilterFieldN,FlowFilterN)

Purpose:  Used to return a field based on the record key generated by the NL function. The NL function returns unique records, whereas the NF function returns the detail of each and every record.

Parameters

It is one of many Jet functions like NL, NP and GL etc. It has the following parameter options.

1. Key
   Record key returned by the NL function is specified in this parameter.
   
2. Field
   The name of the field to be returned.

Flow Filters

The name of the first field by which to filter in the Function. For Dynamics NAV users, this can also be an Advanced Dimension. The following special values are allowed as FilterField arguments:  

• FlowFilterField_1
  The name of a field to use in calculating the value to return. Flow filters are only used if a Field is a flow field.

• FlowFilter_1
  The name of the filter to use in calculating the value to return.

• FlowFilterField_N
  Same as FlowFilterField_1 but for FlowFilterField_N. Up to 9 pairs of Flow Filter Field and Flow Filter pairs can be included in an NF Function.

• FlowFilter_N
  Same as FlowFilter_1 but for FlowFilter_N.

Individual Examples of the NF function

This NF returns the Customer No. flow field from the record key in cell C3 and filters it for January 2020.

fx = NF(C3,”Customer No.”,”Date Filter”,”1/1/2020..1/31/2020″)

This NF returns the Name field from the NL record key in cell B3.

fx = NF(B3,”Name”)

This NF returns the Address field from the NL record key in cell B3.

fx = NF(B3,”Address”)

If You Need Any Help, Contact us Now!