Hi Marit,
You definitely aren't stupid because this ins't an easy thing, unless you know how. Here is my function to count the number records from the Sales Invoice Lines where the Amount does not equal the Amount including Tax. =NL("Count","sales invoice line",,"Amount","=""<>""&NL(""First"",""Sales invoice line"",""Amount including tax"",""document No."",NF(,""document No.""),""line No."",NF(,""line No.""))")This builds on the concept of the sort by sum (https://community.jetreports.com/viewtopic.php?f=23&t=2109&p=10489&hilit=sort+by+sum#p10489) but uses a query as a filter value instead of the filter field.
The most important part is the "=""<>""&NL stynax to get the <> sign to be recognized.
Hope that helps.
Date
Votes
2 comments
-
Jet Reports Historic Posts Hi guys,
I'm trying to do the following for a customer, using NAV2013:
- CountUnique of Sales Invoice Lines when 2 fields of them do not match. That means:
"Position fuer" <> "Endkundennr."
Both fields are fiels of the Sales Invoce Line.
Maybe I'm stupid or I only don't see what the solution could be. Can anybody help me with that?
Best regards
Marit -
Jet Reports Historic Posts Hi Jet-btr,
I try to understand what that Expression does and will match it to my query hopefully successful tomorrow. Tonight I only see signs and numbers. :)
Thank you very much for your reply. Hopefully, I can handle it. ;)
CU
Please sign in to leave a comment.