0

Sorting a "Difference" result

Jet Reports Historic Posts

March 05, 2015 18:25

None

Follow

Good Afternoon!

Can anyone advise how I can apply a "+Created Date", "*" filter to sort the result of the below Jet statement by the Created Date instead of the Document No. that it keeps doing? Or is it a case of needing to leverage Excel post report?

=NL("Rows",NP("Difference",NL("Filter","Sales Line","Document No.","No.","MK-STAGED","Gen. Bus. Posting Group","Builder"),NL("Filter","Sales Line","Document No.","No.","MK-RECEIVED|MK-INTRANSIT","Gen. Bus. Posting Group","Builder",)))

Any help is appreciated.

• Facebook
• Twitter
• LinkedIn

2 comments

• 
  Jet Reports Historic Posts March 05, 2015 23:13 Official comment

  Hello -
  
  Since we cannot sort the results of the NP(Difference) function (it performs its own sorting), let's go about this slightly differently. Let's use the results of the NP(Difference) as a filter.
  
  How about something like this?
  
  =NL("Rows","Sales Line","Document No.","Document No.",NP("Difference",NL("Filter","Sales Line","Document No.","No.","MK-STAGED","Gen. Bus. Posting Group","Builder"),NL("Filter","Sales Line","Document No.","No.","MK-RECEIVED|MK-INTRANSIT","Gen. Bus. Posting Group","Builder",)),"+Created Date","*")

• 0
  
  Jet Reports Historic Posts March 06, 2015 13:04

  Not only did this work, it's going to help me finish 2 other reports I was struggling with a bit by the end of today!
  
  Thank you a million times over!