0

FilterField has an empty filter argument but when I use "@@" I get a different error

Hi, I'm trying to fix an error on my NL Key function.

When I do not preface the filter reference cell with "@@" I get the error: The FilterField "Transaction No." has an empty Filter argument, which is not allowed.

When I do preface the filter reference cell with "@@" I get the error: Invalid filter "@@"

Formula is below. No issues with Document No. or Posting Date when I have added "@@" prefix, just seems to be an issue with the Transaction No.

=NL("Rows=2","G/L Entry",,"Document No.","@@"&AA11,"G/L Account No.",H11,"Posting Date","@@"&AB11,"Transaction No.","@@"&I11)

If anyone has a solution/workaround or can explain why the Transaction No. field is throwing up errors when the other filters are not I would greatly appreciate it.

 

Thanks.

1 comment

Please sign in to leave a comment.