when listing G/L Entry movements, sorting by field "Description", I want to get just one line for each "Description", totalling all the amount of all the lines with the same "Description".
The best thing I get is making Subtotals in Excel for changes in "Description", but any suggestion on how to obtain just a line for each "Description" totals, with Jet formula combination?
Date
Votes
2 comments
-
Jet Reports Historic Posts well, using this formula:
NL("Rows";"G/L Entry";"Description";G/L Account No.";$F14;"Posting Date";"01/01/2011..31/12/2011")
I get rows for each description, but when I put this formula in the same row(right), I get the correct value for the first row, and for the next rows just 0 or #VALUE.
NL("Sum";"G/L Entry";"Amount";"Description";"@@"&$F15;"G/L Account Nº";$F14;"Posting Date";"01/01/2011..31/12/2011")
"Conexión Nav Server 1","CAMPEZO","G/L Account","62200000000" 62200000000
description1 274
"Conexión Nav Server 1","CAMPEZO","G/L Account","62210000000" 62210000000
description2 197,4
description3 0
is it possible to put those two NL formulas on the same row?how? -
Jet Reports Historic Posts This is definitely possible and a very common practice. With a little more information, I hope I can help get the report to return the information you need.
I'm curious as to what is referenced in cell F14 in your report. And in your example results, it looks like there is a record key being returned as well. Is that coming from another NL() function that does not contain a field cache?
Please sign in to leave a comment.