0

multiple filters on same table/field?

Question
I am pulling some info from the Purchase Header table, but i needed to filter on data located in a different table, so i used an NL filter, it is below.

=NL("Filter","Document Dimension","Document No.","Table ID","39","Document Type","Order","Dimension Code","05 PROGRAM","Dimension Value Code","455")

This works fine for me, but i would like to add another filter to this NL, example

Dimension Code 04 BUDGET CENTER
Dimension Value Code "070"

Can i add this filter to my original NL that i have above?? Right now i have ("Dimension Code","05 PROGRAM","Dimension Value Code","455"), can i also add ("Dimension Code","04 BUDGET CENTER","Dimension Value Code","070").

Thanx

Craig

1 comment

Please sign in to leave a comment.