Hello, I know how to filter the values inside Excel with formulas but I would like to know if this is possible to do it directly on the values with the Filters.
Exemble
Filter:
Shape = Rectangle or Thickness = 10
Thank you :D
Date
Votes
3 comments
-
Jet Reports Historic Posts Hi,
I'm not positive I understand your question exactly. Are you talking about filters in Jet formulas or are you talking about something else in Excel?
Regards,
Hughes -
Jet Reports Historic Posts I want to filter the value in the jetreport formula. I don't know how to do OR filters, only AND filters.
-
Jet Reports Historic Posts So basically, you can't do an OR filter with 2 different fields. What you can do is use an NP(Union) function to get the union of 2 sets which is the equivalent of an OR filter. It might look something like this:
=NL("Rows",NP("Union",NL("Filter","Customer","No.","Shape","Rectangle"),NL("Filter","Customer","No.","Thickness","10")))
Does that answer the question?
Regards,
Hughes
Please sign in to leave a comment.