Sign Up for Training |
Jet Express Support |
Jet Reports Company Site
Jet 365 Financials
Jet Professional
Jet Enterprise
Downloads
Community
Submit a Request
Give Feedback

NF Function Reference


=NF (Key,Field,FlowFilterField_1,FlowFilter_1,FlowFilter_2,..., FlowFilterField_N,FlowFilter_N)

Purpose:  Returns a fields based on a record key.  Record keys can be generated from the NL function.

Help Topics

NL Function
NP Function
GL Function

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

Parameter Description
Key Specifies a record key returned by the NL function when the Field parameter is blank or has 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.
  The following flow filter fields and flow filters are only available in Dynamics NAV.
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.

NF Function Examples

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.