0

one table, rows where two fields are different

Jet Reports Historic Posts

August 29, 2012 13:25

None

Follow

Hi,

I want to get all rows of a table where field "description" is unequal to field "description 2".

I've tried it with this formula:
=NL("rows";"Verkaufslieferzeile";;"Posting Date";"31012011";"description";"<>description 2";"Art";"Article")But with this one I get a list af all rows.

Can anyone help me?

Thank you!

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Jet Reports Historic Posts August 29, 2012 14:06

  Hi,
  
  Assuming you are using Navision, you can use a calculated filter for this. It would be something like this:
  
  =NL("rows";"Verkaufslieferzeile";;"Posting Date";"31012011";"description";"=""<>""&NF(,""description 2"")";"Art";"Article")
  Does this help?
  
  Regards,
  Hughes