0

Counting Orders with specific Item Category Codes

I'd like to Count the Invoices that have multiple Item Category Codes.
We are using NAV 5.0 SP1. My current formula seems to return orders that have one of the Item Category Codes OR the other. Not ones that specifically have both.

Thoughts?

I've tried the value of value of $F6 as (from our Item Category Codes):
DISPLAY
HOME ACC
DISPLAY|HOME ACC
without the desired results :-(

=NL("Count","Sales Invoice Header",,"Posting Date",$G$2,"No.",NL("Filter","Sales Invoice Line","Document No.","Item Category Code",$F6,"Location Code",G$4))

Thanks!

1 comment

Please sign in to leave a comment.