I thought this was simple but I have searched everywhere and cannot find a solution. I need to return all "Purchase Line" rows where the "Outstanding Quantity" is greater than the "Reserved Quantity". Below is the latest formulas I tried based on some research I found. but when I use debug it tells me that ">NF(,""Reserved Quantity"")" is not a valid filter. Anyone have any ideas.
=NL("First","Purchase Line","Document No.","No.",$F9,"Variant Code",$H9,"Outstanding Quantity",">NF(,""Reserved Quantity"")")
Date
Votes
4 comments
-
Jet Reports Historic Posts Almost except:
NL("Rows";"Purchase Line";"Document No.";"No.";$F9;"Variant Code";$H9;"=NF(;""Outstanding Quantity"") > NF(;""Reserved Quantity"")";TRUE) -
Jet Reports Historic Posts Thanks for the help suggestion Sebastiaan. I was not able to get yours to work, Excel kept complaining about not a valid formula and I could not figure out where the quote was missing but you did show me did not work. It apears you cannot compare a field to a NF in this scenario you have to compare NF to NF. I also heard back from my VAR and he supplied me with the below solution which did work for me just in case anyone else finds it helpfull.
Solution
=NL("First","Purchase Line","Document No.","No.",$F9,"Variant Code",$H9, "=NF(,""Outstanding Amount"")-NF(,""Reserved Quantity"")",">0") -
Jet Reports Historic Posts Happy to be of service…
Yeah probably because all the ; needed be replaced with ,
However your solution is a bit more expansive in processing time because it needs to do a calculation and then a compare. -
Jet Reports Historic Posts That was the issue. I changed out all the ; and it worked perfectly. Thanks again.
Please sign in to leave a comment.