Filtering using <> and cell reference

Jet Reports Historic Posts

April 13, 2010 16:10

None

I have probably the simplest question but I am really strugeling. I want to use a <> or < in a filter with a cell reference in a nl() function. It looks like this: NL("Sum";"Sales Line";"Quantity";"Pref Shipment Date";"<>B3";"No.";"XYZ") where B3 is the cell reference. I am probably using the wrong quotes (one double quote) in this filter as it sees not the cell reference but the value B3. Can someone please tell me which quotes or syntax to use? Thanks, Andor

Date Votes

2 comments

Jet Reports Historic Posts April 14, 2010 15:52 Official comment

Hi Andor,

Try something like this:

=NL("Sum";"Sales Line";"Quantity";"Pref Shipment Date";"<>"&B3;"No.";"XYZ")
Does that work for you?

Regards,
Hughes

Comment actions Permalink
0

Jet Reports Historic Posts April 15, 2010 06:50

Hughes, Thanks that did the trick, Andor

Comment actions Permalink

Please sign in to leave a comment.