0

Create a list where 2 fields are not equal

Jet Reports Historic Posts

March 18, 2009 18:51

None

Follow

Hi,

I am trying to create an NL function with a filter criteria that one field in that table does not equal a different field in the same table. i.e. A list of sales orders where your ship to address does not equal your bill to address. Could anyone give me any direction as how to do this?

Thanks

Tammy

• Facebook
• Twitter
• LinkedIn

2 comments

• 0
  
  Jet Reports Historic Posts March 18, 2009 19:16

  Hi Twarwick,
  
  Try this:
  
  =NL("Rows","Sales Header",,"Dcoument type","Order","No.","=IF(NF(,""Ship to Address)"")<>NF(,""Bill to Address""),NF(,""No.""))")
  You may need to check the accurate names of the fields. And please let me know the result.

• 0
  
  Jet Reports Historic Posts March 18, 2009 21:14

  Thanks,
  
  That was exactly what I was looking for!