0

sorting sum

Sharon Bunker

September 20, 2017 18:23

Answered

Follow

 I am having problems trying to get this report to sort. I have tried adding a function and such an it is not working for me. Can someone let me know what I am doing incorrectly?

=NL("rows","item ledger entry","source no.","source no.",$G$6,"41 Source Type","Customer","3 Posting Date",$G$5)

=NL("rows","item ledger entry","item no.","source no.",$G$6,"41 Source Type","Customer","3 Posting Date",$G$5)

=-NL("sum","item ledger entry","quantity","posting date",G$5,"source no.",$E$11,"item no.",$F11,"41 Source Type","Customer")

=NL("sum","sales invoice line","amount","shipment date",G$5,"type","item","no.",$F11,"sell-to customer no.",$E$11)

 

 

 

• Facebook
• Twitter
• LinkedIn

2 comments

• 0
  
  Harry Lewis September 21, 2017 19:37

  Hello Sharon -

  While you didn't state by what value you wanted to sort, here's an example (I created a Grouping Report to which I applied the Sort-by-Sum technique)

  The results looks like this:

  

  Here is the design:

  (right-click image and select Open Image in new tab to view a larger size)

  I hope that helps get you pointed in the right direction

• 1
  
  Sharon Bunker September 21, 2017 20:34

  Thank you. This does help me.