Hi,
I am trying to bring in one line for each serial number from the service ledger entry. How do I add one row for each serial number (I then have formulas to add the sum of the labor, parts, total, and YTD costs for that serial number in the posting date range) instead or using the rows NL function which lists the serial number multiple times in that posting date range for each invoice?
Thanks
Eric
Date
Votes
1 comment
-
Jet Reports Historic Posts What is the current way you are doing this? Can you post your function?
To just return a unique list of Serial numbers from the service ledger entry table it would be something like:=NL("rows","Service Ledger Entry","Serial No. (Serviced)","Posting Date",$C$4)where C4 is a date range.
If you want to see every time a serial number is listed in the table, you will need to do a data dump using the NL with the NF function. (if a serial number had multiple services performed against it)=NL("rows","Service Ledger Entry",,"Posting Date",$C$4) (in E7) =NF($E7,"Serial No. (Serviced)")
Please sign in to leave a comment.