0

NL Rows sort order

Jet Reports Historic Posts

August 06, 2015 12:17

None

Follow

Hi,

Jet 15.1. Data source is NAV 2013.

I am returning rows using the following NL function:

=NL("Rows","LOB Posted Table","Customer Account No.","Customer Account No.",$I$5) (Where LOB Posted Table is a custom NAV table).

The rows are returned in alphabetical order of Customer Account No i.e. A1, A2, B1 etc etc). I would like it to sort by a count function (with date filter) - how do I do this please?

Many thanks in advance.

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Jet Reports Historic Posts August 06, 2015 15:48

  Hi rniblock,
  
  It looks like you need to use the "sort by sum" functionality. Please check out this post on how to do it.
  
  https://community.jetreports.com/viewtopic.php?f=23&t=2109&p=10485&hilit=sort+by+sum#p10485
  
  The big difference in your situation is that you will want to use a nested NL(count) instead of a nested NL(sum) function.
  
  I hope this helps!