Hello,
I'm trying to create a report based around Total Weight for customers dependent on Posting Date. The report currently brings through all customers and the sum of weights between the dates set fine, however it brings through ALL customers, even the ones with a Total Weight of 0. The formula for the Total Weight is below:=NL("Sum","Sales Shipment Header","TotalWeight","Sell-to Customer No.",G14,"Posting/Tax Point Date",$F14)I've therefore created a simple IF to hide all the rows with a 0 value but this is creating a large report and taking a long time to run.
To solve this I've been trying to filter the rows beforehand with a "Greater than 0" filter linked to the Total Weight field. The formula is shown below:=NL("Rows=8","Customer",,"Filters=",$E$3:$F$5,"Limit=",3,"Link=","Sales Shipment Header","Sell-to Customer No.","=No.","TotalWeight",">0")Upon running however it still brings through the weights with a 0 value..
Any ideas, thanks.
Date
Votes
1 comment
-
Jet Reports Historic Posts Was solved using this formula instead, to check for any 0 values while the customer table is being read..
=NL("Rows=8","Customer",,"No.",NL("Filter","Sales Shipment Header","Sell-to Customer No.","Posting/Tax Point Date",D8),"Filters=",$E$3:$F$5)
Please sign in to leave a comment.