0

How can I create an "OR" statement in a jet formula?

Jet Reports Historic Posts

July 17, 2015 13:57

None

Follow

Hello Biru,

You will want to use an NL(Rows(NP(Union)) to get a combined list. For more information on how to use this, please see Jet Reports' knowledgebase article on using Array Calculations: http://kb.jetreports.com/article/AA-00498

If you still need some help just let me know.

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Jet Reports Historic Posts July 17, 2015 13:57

  Hello,
  
  I would like to know if it’s possible to create an “OR” condition in a Jet key?. What’s the proper format to build this “OR” condition? If someone can give me some guidance it would be greatly appreciated. Below is an example of what I’m trying to achieve.
  
  Ex:
  
  =NL("Rows","Item","No.","No.",10,"68 Inventory",<>0) OR NL("Rows","Item","No.","No.",10,"Qty. on Purch. Order",<>0)