Hi all,
hope someone can help me out here,
i have
following NL which is working fine,
=NL("sum";"custom table";"open qty";"compagny=";"compagny x";"partnr.";$B10;"date";$T$4;"Projectnr. config.";"*")
Now i need to rebuild it,
it needs to do the sum only when status code = concept or order
where "projectnr. config." in the NL = Nr. from table "project"
which I need to pull from another table "project"
field = status code filter= order|concept
I hope this is clear,
looking for any help, which is much appriciated
Jasmon
Date
Votes
3 comments
-
Jet Reports Historic Posts Official comment your advised code was the answer for my quistion ….. but by using your code I found out that the result was not as I excepted,
the final solution was to use an NF instead to get the result I was looking for :D
But I learned from your code, and was able to use it in other pleaces anyway
So thanks !
* still learing about Jet basics * 8-) -
Jet Reports Historic Posts Hi Jasmon,
I think what you want might be something like this:
=NL("sum";"custom table";"open qty";"compagny=";"compagny x";"partnr.";$B10;"date";$T$4;"Link=";"Project";"Nr.";"=Projectnr. config.";"status code";"order|concept")
I am making the assumption that the status code field is on the "Project" table and not on "custom table". Is that correct?
Regards,
Hughes -
Jet Reports Historic Posts Hi Jasmon,
I think what you want might be something like this:
=NL("sum";"custom table";"open qty";"compagny=";"compagny x";"partnr.";$B10;"date";$T$4;"Link=";"Project";"Nr.";"=Projectnr. config.";"status code";"order|concept")
I am making the assumption that the status code field is on the "Project" table and not on "custom table". Is that correct?
Regards,
Hughes
Yep that's correct, the status code is pulled from the "project" table"
I wil try your code
Thanks for your quick reply,
Jasmon
Please sign in to leave a comment.