I've tried to create a report from the Item Ledger Entry table that will compare item sales between the same period this year as last year using a date filter. I'm having a problem grouping all sales for the same item into my two columns. Any suggestions?
Date
Votes
1 comment
-
Jet Reports Historic Posts Hi,
I'm assuming you are doing something like replicating item numbers with an NL(Rows) function like this:
=NL("Rows","Item Ledger Entry","Item No.",…)
Then to the right of that, you would just use 2 NL(Sum) formulas to get the sales amounts for your specified posting dates for each item. Something like this:
=NL("Sum","Item Ledger Entry","Sales Amount (Actual)","Posting Date",[posting date range],"Item No.",[cell reference to NL(Rows) formula])
Does that make sense?
Regards,
Hughes
Please sign in to leave a comment.