Sign Up for Training |
Jet Global Company Site
Community
Downloads
Submit a Request
Give Feedback

NF Function Reference


Related Articles...

Overview

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

Purpose:  Returns a field based on a record key generated with an NL function.

For more general information about the NF function, see Introducing the NF Function

In Dynamics NAV, when an NL function returns a record key, the Flow Filters from the NL function are not used to calculate the return value of the NF function.  Rather, the Flow Field returned by the NF function is calculated based on the Flow filters applied in the NF function.

Parameters

  • Key

    Specifies a record key returned by the NL function (when the NL function's Field parameter is either blank or contains a Field Cache).

  • Field

    Name of the field to return.  The field specified must be present in the Field Cache in the NL function if a Field Cache is being used.

Flow Filters

The following flow filter fields and flow filters are only available in Dynamics NAV.

The name of the first field by which to filter.  For Dynamics NAV users, this can also be an Advanced Dimention.  

The following special values are allowed as FilterField arguments:  

  • FlowFilterField_1

    The name of a flow filter 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 flow filter to use in calculating the value to return. Flow filters are only used if Field is a flow field.

  • FlowFilterField_N

    Same as Filter_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 Filter_1 but for FlowFilterField_N.


Examples of the NF function

This NF returns the Net Change flow field from the record key in cell A3 and filters it for January 2020.. 

=NF(A3,"Net Change","Date Filter","1/1/2020..1/31/2020")

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

=NF(B3,"Name")

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

=NF(B3,"City")

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

  • Avatar
    j2associates

    It would be helpful to have a few more Flow Field examples as they are less well known.