I've been using Jet for quite some time but just started to play around with the nl("table") function. I have this formula : =nl("table","ITEM LEDGER ENTRY",{"Item No.","quantity","Sales Amount (actual)"},"entry type","Sale"). The problem I have is that the table is only listing one row for each unique criteria. I did try including the entry number and it would then include a row for all of the items, but I would rather it do a sum instead. How do I get it to do a "sum" on the quantity and Sales Amount (actual) fields?
Date
Votes
5 comments
-
Jet Reports Historic Posts Hi,
This is fairly easy to do with the Jet Table Builder tool. I think what you actually want is to make Item your primary table and then add Item Ledger Entry as a linked table and add sum fields from the Item Ledger Entry for the fields you want to sum. Does that work for you if you use the Table Builder?
Regards,
Hughes -
Jet Reports Historic Posts Thank you. That fixed my problem. I'm going to have to play around with tables a whole lot more to figure out how to make them work like I want.
-
Jet Reports Historic Posts Now I would like to link to the customer table and return a row for each item and customer staticstcs group and then sum the item sales and quantity for each. I have linked to the customer table and it listing a statistics group but only for the first record it finds. The total for invoiced quantity and sales amount is the total for all statistics group not just the one listed. My main table is the item table which is linked to item ledger entry table which is linked to customer table.
-
Jet Reports Historic Posts What you're trying to do there isn't possible in an NL(Table). You would need to do a grouping report with multiple NL(Rows) replicators in order to do that. You can't do things in an NL(Table) that would require multiple NL(Rows) functions normally.
Regards,
Hughes -
Jet Reports Historic Posts Thank you. I don't feel so bad now for not being able to figure it out.
Please sign in to leave a comment.