0

Using a Count filter

Hello,

I need to build a report to list production order component lines where at least one line doesn't have a location code. This is how I'm selecting the records:

=NL("Rows","Prod. Order Line",,"Status","<>Finished","Remaining Quantity",">0")

Then I have a column that counts the rows with no location code:

=NL("Count","Prod. Order Component",,"Prod. Order No.",$E4,"Item Code",$G4,"Location Code","=@@")

Then I can create hide logic to hide the rows where the Count is = 0.

But instead of doing that, can I combine the NL Rows and NL Count formulas into one so I don't have to use the Hide logic?

Thanks for any help!

1 comment

Please sign in to leave a comment.