0

How do I create an option to filter off the rows result

Jet Reports Historic Posts

January 06, 2014 05:05

None

Follow

Hi Derrick,

I'm not sure exactly what you mean. Do you want to filter the NL(Rows) function so that it doesn't return zeros? You can create a sheet in Excel that is an options sheet and then in your NL(Rows) formula you can reference the filter value on that sheet. You can filter out zeros with a filter value of "<>0". Does that help?

Regards,
Hughes

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Jet Reports Historic Posts January 06, 2014 05:05

  Hi,
  
  I want to create an option to filter off the 0 amount that's are generate by rows.
  How should I do it?
  
  :D
  
  Appreciate all the kind advise.