0

Omit rows where the Amount = 0

Jake Beliveau

March 14, 2018 15:15

None

Follow

I am trying to build a report that will bring in records with certain parameters (filters).  Every other parameter works fine and I'm getting the results I'm looking for.  However, I'm having trouble eliminating rows where the Amount =0.

I have my filters set up in A2:B4 and tried adding Amount with the filter of >0.  I've tried every combination of ">0",">"&0,">&0",">"0, but nothing seems to work.

=NL("Rows","Sales line",,"filters=",$A$2:$B$4,"Amount",">"&0)

Can anyone advise?

• Facebook
• Twitter
• LinkedIn

2 comments

• 0
  
  Harry Lewis March 14, 2018 15:30

  Hi Jake -

  Here's something that could make a difference.

  Row 1 and Column A are reserved for Jet keywords, so you'll want to move your filters over to the next column (B and C).

  =NL("Rows","Sales line",,"filters=",$B$2:$C$4,"Amount",">0")

  Other than that, your function appears to operate correctly:

  without filter:                                      with filter:

  

• 0
  
  Jake Beliveau April 16, 2018 16:45

  Thanks, Harry!  Appreciate you.