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.
- Key
Record key returned by the NL function is specified in this parameter. - 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”)
