0

Filtering Rows based on multiple variables

Jet Reports Historic Posts

June 20, 2014 20:46

None

Follow

Hi all.

I am trying to return rows based on whether two different things are true. I want to return the g/l account (NAV 2013) only if there is a non-zero amount in either the Actuals or Budget field. I can figure out how to make it return based on one or the other, but not both.

Anyone else ever tried to do this and been successful?

• Facebook
• Twitter
• LinkedIn

3 comments

• 0
  
  Jet Reports Historic Posts July 01, 2014 09:15

  Sounds like you need conditional hide in column B
  
  HTH
  
  rmw

• 0
  
  Jet Reports Historic Posts July 01, 2014 12:21

  Hi bkiester,
  
  Perhaps you can try something like this:
  
  
  and use its result as a filter value in a NL("Row"…).
  Of course replace the dates with a cell-reference based on Option-sheet values.
  
  Best regards
  Gerard
• 0
  
  Jet Reports Historic Posts November 18, 2014 22:22

  Gerard,
  
  Thank you so much! Sorry I didn't see this response before now, I believe that solution will work brilliantly!
  
  Best Regards,
  
  Brian