Hi,
Kindly help me reconstruct this formula –>
=NL("Rows","Purchase Header","No.","Posting Date",$B$2,"Document Type","Order","Status","Released","No.",NL ("Filter","Purchase Line","Document No.","Document No.","POI*","=Local(NF(,""Quantity Received"")<NF(,""Quantity""))",TRUE,"=Local(NF(,""Planned Receipt Date"")<(""$B$2""))",TRUE))
am getting the error "Report may exceed Excel's row and column limits, fomrula may be too long, or formula may contain both nested functions and named ranges." I also got the formula of comparing 2 fields in the same table here.
I want to the get the PO Nos. that Quantity Received is less than Quantity (PO'ed Qty) and
Planned Receipt Date is less than the End Date ($B$2) that i specified in Option.
Thank you very much in advance.
Mye
Date
Votes
5 comments
-
Jet Reports Historic Posts Hi Mye,
You should be able to get rid of the error message fairly easily by putting the NL(Filter) function in another formula. I also don't think your second calculated field is quite right. Try this:
C2:=NL("Filter","Purchase Line","Document No.","Document No.","POI*","=Local(NF(,""Quantity Received"")<NF(,""Quantity""))",TRUE,"=Local(NF(,""Planned Receipt Date"")<VALUE("""&$B$2&"""))",TRUE)C3:=NL("Rows","Purchase Header","No.","Posting Date",$B$2,"Document Type","Order","Status","Released","No.",$C$2)
Does that work for you?
Regards,
Hughes -
Jet Reports Historic Posts Hi Hughes,
Thanks for the prompt reply. It now gives me an error "Invalid filter.." pertaining to C2.
Mye -
Jet Reports Historic Posts Mye,
Are you using the latest version of Jet Reports 2009? For me, it is not giving this error, so I'm just wondering what version of Jet Reports you are using.
Regard,
Hughes -
Jet Reports Historic Posts Hi Hughes,
Am using Jet version 7.1.2
Mye -
Jet Reports Historic Posts Hi Mye,
I would try the latest version of Jet Reports if I were you. I'm not sure about Jet Reports v7, but I think the latest version would work for what you're trying to do.
Regards,
Hughes
Please sign in to leave a comment.