I am trying to use the previous example of sorting on a nested NL Sum but cannot get it to work. Can someone please by a second set of eyes and tell me what stupid mistake I am making. This report is using Sales Shipment line and I am trying to sort in descending order the sum of the quantity of shipment lines. In this case they are gallons, and there are several filters set. Please help with this, it has been driving me crazy. thanks Patrick
PS. I have attached the Jet report.
Date
Votes
3 comments
-
Jet Reports Historic Posts Official comment this is fixed and running great. I was off on where I put the NL sort by sum function also. You can see the attached report and what Jet Support and Jennifer Bride helped me with. Jet support is awesome as well as this community.
thanks for all the help. -
Jet Reports Historic Posts Just off the bat, it looks like the problem is that you've got your sort by sum filter in D7 but it's referencing a bunch of values in row 18 which are being replicated and then it's being used by the formula in row 20. You'll need to move your sort by sum filter down into row 20 so that it gets replicated with the different filter values in order for that to work. Does that make sense?
Regards,
Hughes -
Jet Reports Historic Posts Thanks, that was one my mistakes and now am trying to run it again and then see if it works. Plus I needed to move the NL sort by sum function to the Sell to customer group function then the customer numbers will come in already sorted by the quantity. thanks for the additional help.
Patrick
Please sign in to leave a comment.