I would like to sum by document number from the GL Ledger. I have multiple entries per document number, some of which occur on different posting dates. I am trying to list all the unique document numbers down a column using the NL("Rows") function, then sum transactions using the document number as a filter. The problem is the document number itself is getting listed more than once, it comes back for each different posting date, so if the same document number has a posting on 3 different dates, I get the document number 3 times. Any suggestions?
Date
Votes
1 comment
-
Jet Reports Historic Posts The reason you don't get the "unique" document number is because you didn't state the field in the third argument of your NL:
=NL("Rows";"G/L Entry";)
Will generate a row for every g/l entry
=NL("Rows";"G/L Entry";"Document No.")
Will generate a row for every unique Document No.
Imagine if that formula is in cell C3, this in cell D3 will return the count:
=NL("Count";"G/L Entry";;"Document No.";C3)
Please sign in to leave a comment.