Hello,
Is there a way to do something like this?
C3 = =NL("Filter";"Sales Invoice Line";"Quantity (Base)";"Sell-to Customer No.";$I$4;"No.";NF(;"Item No.");"Document No.";NL("Filter";"Sales Invoice Header";"No.";"Order Date";$E$5))
C4 = =NL("Filter";"Sales Cr. Memo Line";"Quantity (Base)";"Sell-to Customer No.";$I$4;"No.";NF(;"Item No.");"Document No.";NL("Filter";"Sales Cr. Memo Header";"No.";"Order Date";$E$5))
C7 = "-=NL(""SUM"";NP(""Union"";"""&$C$3&""";"""&$C$4&"""))"
D7 = NL("Rows=7";"Item Cross Reference";"Item No.";"Item No.";$I$6;"Cross-Reference Type No.";$E$4;C16;"*")
Thanks,
Elena
Date
Votes
3 comments
-
Jet Reports Historic Posts I think I managed to find another way to obtain what I need with something like this:
C7 = "-=(NL(""SUM"";""113"";""Amount"";""Sell-to Customer No."";"""&$N$4&""";""No."";NF(;""Item No."");""Document No."";NL(""Filter"";""112"";""No.""))+NL(""SUM"";""115"";""Amount"";""Sell-to Customer No."";"""&$N$4&""";""No."";NF(;""Item No."");""Document No."";NL(""Filter"";""114"";""No."")))"
but…
I need to add another filter (Posting Date) and my formula would look like this:
C7 = "-=(NL(""SUM"";""113"";""Amount"";""Sell-to Customer No."";"""&$N$4&""";""No."";NF(;""Item No."");""Document No."";NL(""Filter"";""112"";""No."";""Posting Date"";"""&$J$5&"""))-NL(""SUM"";""115"";""Amount"";""Sell-to Customer No."";"""&$N$4&""";""No."";NF(;""Item No."");""Document No."";NL(""Filter"";""114"";""No."";""Posting Date"";"""&$J$5&""")))"
…in this situation there are too many characters and the formula cannot be evaluated.
Any idea about how I could short it up?
Thanks,
Elena -
Jet Reports Historic Posts Hi Elena,
You should be able to shorten it fairly easily. First, when you are using table and field numbers you don't need quotes around them. So instead of ""113"", you can just put 113. Secondly, you should be able to replace all the fields in your formulas with field numbers. If you don't know the field numbers, you can get them from the Jet Browser by expanding the details section and then selecting the fields. I'm guessing that converting all the fields to numbers will easily get you under the 256 character limit. Does that help?
Regards,
Hughes -
Jet Reports Historic Posts Yep - working great!
Thask you, Hughes!
Please sign in to leave a comment.