New post
0

Filter Join / And

Avatar
Jet Reports Historic Posts
None
Follow

Hi,

Can I please pick your brain on what I am trying to achieve.

I am hoping to use NL(filter) using the Ledger Entry Dimension table to get "entry no." filter value where an entry number has 2 different values. Sound very confusing I know :shock: , but here are the different formulas I tried that obviously are not working…

NL("Filter","Ledger Entry Dimension","Entry No.","Entry No.",NP("Union",NL("Filter","Ledger Entry Dimension","Entry No.","Dimension Value Code",$F$6),NL("Filter","Ledger Entry Dimension","Entry No.","Dimension Value Code",$F$7)))

NL("Filter","Ledger Entry Dimension","Entry No.","Dimension Value Code",$F$6&$F$7)

I basically want to get a list (filter) of entry no.s where an entry no. in the Ledger Entry Dimension table has both Dimension Value Code of F6 AND F7. For those who are not familiar with the Ledger Entry Dimension table, this table holds the dimensions 3 - 8 for gl entries. A GL Entry No. in this table can have an entry for each dimension value used in the gl entry.

Hope these all make sense ;)

Thanks all for your help in advance.

Date Votes

1 comment

Please sign in to leave a comment.