Hi guys,
Its been a while since I've been on here so excuse me if i sound a bit out of it.
Anyway my client wants to sum shipment values that have been shipped within 24 hours of the Order date.
This in itself is easy, however if an Order is placed on Friday and Shipped on the Monday, this should count as well.
The formula i've come up with is=nl("Sum","Sales Shipment Line","Quantity","Type","<>''","Quantity",">0","Item Category Code",$C11,"Sell-To Customer No.",$C$5,"order Date",$C$6,"Shipment Date",np("DateFilter",nf(,"Order Date"),nl("First","Date","Period Start","Period Start",np("DateFilter",nf(,"Order Date")+1,nf(,"Order Date")+3),"Period Type","Date","Period Name","Monday|Tuesday|Wednesday|Thursday|Friday")))Which is over 300 characters
Can anyone help me shorten this please?
Cheers for any help in advance
Bromy
Date
Votes
1 comment
-
Jet Reports Historic Posts NL("Sum";111;15;5;"<>''";15;">0";5709;$C11;2;$C$5;"Order Date";$C$6;10;NP("DateFilter";NF(;"Order Date");NL("First";"Date";2;2;NP("DateFilter";NF(;"Order Date")+1;NF(;"Order Date")+3);1;"Date";5;"Monday|Tuesday|Wednesday|Thursday|Friday")))
Order Date is not in our database so you could possibly also replace that one. Also instead for Period Name you can use either Monday..Friday or use Period No. 1..5
Please sign in to leave a comment.