Hi All,
using Jet Reports and Excel 2003 with Nav 5, I am looking to get results by an NL function under the condition that another NL functions returns the right value for these results.
Case:
Show me certain customer IDs from the Item Ledger Entry within a certain date range IF it is the first occurance of an entry for that customer ever. This is how I tried it (translated from German), but it returns no value:
=NL("Rows";"Item Ledger Entry";"Source Nr.";"=NL(""First"";""Item Ledger Entry"";""Posting Date"";""+Posting Date"";""*"";""Source Nr."";NF(;""Source Nr.""))";"="&[field with date range]")
Thanks for your help!
Date
Votes
1 comment
-
Jet Reports Historic Posts Hi,
I think you are fairly close. I believe you may be missing a filter for Source Type to ensure that you are only getting customers. Also, I think I would change your CalcFilterField to be a CalcFilter. Assuming your date range is in cell D5, it might look something like this:
=NL("Rows";"Item Ledger Entry";"Source Nr.";"Source Type";"Customer";"Posting Date";D5;"Entry No.";"=NL(""First"";""Item Ledger Entry"";""Entry No."";""+Posting Date"";""*"";""Source Type"";""Customer"";""Source Nr."";NF(;""Source Nr.""))")
Does that work for you?
Regards,
Hughes
Please sign in to leave a comment.