0

Count NL ROWS

Todd Morse

June 20, 2018 14:33

None

Follow

Is there away to use NL Count to Count the number of records returned from NL Rows?  ie Nest the NL Rows inside the NL Count.

 

TIA 

• Facebook
• Twitter
• LinkedIn

3 comments

• 0
  
  Harry Lewis June 20, 2018 17:24

  Hello -

  An NL(Count) function with the same parameters as the NL(Rows) function will return that number.

  For example, let's suppose that I have this NL(Rows) function:

  =NL("Rows","Customer",,"State",$C$5,"Salesperson Code",$C$4,"Balance","<>0")

  and that it returns... 42 customer records.

  If I use this function:

  =NL("Count","Customer",,"State",$C$5,"Salesperson Code",$C$4,"Balance","<>0")

  it will return the value:  42

   

  Does that help?

• 0
  
  Todd Morse June 20, 2018 18:04

  Thanks for the feedback.  With I am trying to do is get a count out unique Sales Order Sales Order Line combinations from the sales shipment line table.  An order -> order line combination can occur more than once in the sales shipment lines for some year to date ontime deliver information.  What I wanted to do is to get the distinct rows for a given date range and location then get the count of records.  Without having to bring in the entire rows dataset.

   

  Edited by Todd Morse June 20, 2018 18:05
• 0
  
  Harry Lewis June 22, 2018 14:16

  Hello Todd -

  You would need some way to uniquely identify the records you want (through a specific set of filters).

  You stated that "an order -> order_line combination can occur more than once... for some year-to-date".  So, you would need to include some other filter in your query to ensure a unique record set. 

  Once you have those filters, the NL(Count) would return the value you need [without having to use an NL(Rows) function to return the actual records].