0

Sorting by Sum

Jet Reports Historic Posts

July 09, 2012 13:27

None

Follow

i'm trying to get a list of Sales between two date :
to do that i used the following formulas :
DateParam is a variable of date filter
H3 =NL("Filtre";"Sales Invoice Line";"No.";"Posting Date";DateParam)
B4=NL("Lignes";"Item";;"No.";$H$3;"-Responsibility Center";"*")
C4=NF(B4;"No.")
F4=NL("Somme";"Sales Invoice Line";"Quantity";"No.";C4;"Posting Date";DateParam)
G4=NL("Somme";"Sales Invoice Line";"Amount";"No.";C4;"Posting Date";DateParam)

i need now to sort those result by Sales Amount or Quantity?
Any suggestions?

• Facebook
• Twitter
• LinkedIn

5 comments

• 
  Jet Reports Historic Posts July 12, 2012 15:22 Official comment

  So mostly this looks correct to me, but there are a couple things that may help. First you are already sorting by Responsibility Center before the sort by sum, so that sort will take precedence. Is that your intention? Also, you may need to change your sort by sum formula to unquote the named range you are referencing like this:
  
  

  ="-=NL(""Somme"";""Sales Invoice Line"";""Quantity"";""No."";NF(;""No."");""Posting Date"";"""&DateParam&""")"

  
  Does that help?
  
  Regards,
  Hughes
• 0
  
  Jet Reports Historic Posts July 09, 2012 15:34

  Hi,
  
  Please read my post on how to sort by sum here:
  
  http://community.jetreports.com/viewtopic.php?f=23&t=2109
  
  Does that help?
  
  Regards,
  Hughes

• 0
  
  Jet Reports Historic Posts July 12, 2012 09:31

  ..

• 0
  
  Jet Reports Historic Posts July 12, 2012 10:14

  Hi,
  
  i followed the instructions described in that post but unfortunately it does not work for me !!
  pleas find attached what i did.
  
  regards,

• 0
  
  Jet Reports Historic Posts July 14, 2012 07:16

  perfect, it works very well.
  
  thanks Hughes,