Hi,
I want to optimise following code
in cell D5NL("rows";"item";;"nr.";"*";"stock";">0";"Max stock";"*";0;"compagnyname";"whscode";"3" )
and =NF($D5;"nr.") =NF($D5;"description")
within the NL it should give me only a list those items where Max stock = > stock
and the qty ove stock
stock 10
max stock 12
list should give me
=NF($D5;"nr.") =NF($D5;"description") ????
item description stock>max
A bike 2
Thanks for sharing any idea's how to get this
Date
Votes
4 comments
-
Jet Reports Historic Posts Hi Jan,
I'm not positive I understand you, but I think you are saying you only want to see items where the value of the Max Stock field is greater than or equal to the value of the Stock field, is that correct? You could use a formula like this I believe:NL("rows";"item";;"nr.";"*";"stock";">0";"Max stock";"="">=""&NF(,""stock"")";0;"compagnyname";"whscode";"3")
Does that work for you?
Regards,
Hughes -
Jet Reports Historic Posts Hi Jan,
I'm not positive I understand you, but I think you are saying you only want to see items where the value of the Max Stock field is greater than or equal to the value of the Stock field, is that correct? You could use a formula like this I believe:NL("rows";"item";;"nr.";"*";"stock";">0";"Max stock";"="">=""&NF(,""stock"")";0;"compagnyname";"whscode";"3")
Does that work for you?
Regards,
Hughes
Almost, now I see how confusing my orginal post must be :-)
and took some time to think it over…..
I want to see only items where stock is >0 AND stock > max stock -
Jet Reports Historic Posts No worries. :-) Let's try again. How about this?
NL("rows";"item";;"nr.";"*";"stock";"="">0&>""&NF(,""Max stock"")";0;"compagnyname";"whscode";"3")
Does that work?
Regards,
Hughes -
Jet Reports Historic Posts Thanks
will look next week, when i'm redesinging the report
and let you know
Please sign in to leave a comment.