Hi ,
I have this query which is very simple
=NL("Sum","Item Ledger Entry","Sales Amount (Actual)","Item No.",G5,"Posting Date","14/3/2012..14/4/2012","Sales Amount (Actual)",">0")
it drill grouping from divison code table to item category table to item to calculate the sum of sale for each item .
the report is working good but my problem is :
the amount if its zero still apperaing for item and i need to skip the item if the related sales amount = 0 …
please its appreciated if any one knows about it ?
Date
Votes
2 comments
-
Jet Reports Historic Posts Hi,
Your SUM query looks correct to me.
But, I think the problem is not in this sum query, maybe it's the other query that got problem.
You saidthe amount if its zero still apperaing for item and i need to skip the item if the related sales amount = 0 …
so, probably the problem is in cell G5, where you pull in the Item No.
Would glad to help more if you can upload your spreadsheet.
Andy -
Jet Reports Historic Posts Hi,
If the problem is that you're trying to show items where the sales amount is greater than zero, then you need to set a filter for that in your NL(Rows) function, not in your NL(Sum) function. The NL(Rows) function is solely in charge of replicating the rows, so you'll need to put your filter for sales amounts greater than zero in that formula, maybe using a flow field. Does that help?
Regards,
Hughes
Please sign in to leave a comment.