0

how I can compare two table fields on the NL filter

Jet Reports Historic Posts

June 18, 2014 18:31

None

Follow

Hi,
I have jet essentials with MS Dynamics NAV and I need to do the following filter on the purchase line table:
select all from purchase line where
no. = <cell reference>, document type = "order", quantity received > quantity invoiced

I can write the NL formula up to the part of "quantity received > quantity invoiced" - not sure how I can compare two table fields on the NL filter.

Anyone could share how to get this done?

This is how I have the NL formula so far:
=nl("rows","purchase line", , "no.", X9, "document type", "order", "quantity received", ???????

Thanks in advance!!!

Fabiana

• Facebook
• Twitter
• LinkedIn

3 comments

• 0
  
  Jet Reports Historic Posts June 20, 2014 07:22

  Hi fabfig,
  
  does this help?
  http://kb.jetreports.com/article/AA-00507
  
  regards
  jetsetter

• 0
  
  Jet Reports Historic Posts June 20, 2014 14:30

  Hi jetsetter
  
  This is exactly what I needed!!!
  Very much appreciated!!!
  
  Kind Regards

• 0
  
  Jet Reports Historic Posts June 23, 2014 08:27

  great! :D
  
  Thanks for Feedback!
  regards
  jetsetter