Hi!
This might be something easy but I just can't seem to figure it out! I am creating a report that will pull a list of Customers that are 90 days behind in payments. I have been able to bring in all of the rows, but it has multiple lines for each customer. I would like to just pull in the sum for each customer so that each customer only has one row and the amount is the total of all the rows that are pulling in right now, but am not sure how to fix this. Any suggestions would be greatly appreciated :)
Thanks so much!
Date
Votes
2 comments
-
Jet Reports Historic Posts Official comment Hi,
This is hard to say without actually seeing what your functions look like but assuming you are using NAV, you probably want to change your NL(Rows) function to replicate rows from the Customer table. Then you could use an NL(Sum) function to sum whatever you need to sum for each customer. Does that help? If not, what do your current Jet functions look like?
Regards,
Hughes -
Jet Reports Historic Posts Oh of course that makes sense! Thank you SO much!!! :mrgreen:
Please sign in to leave a comment.