0

How do I filter and retrieve part of field?

Jet Reports Historic Posts

October 04, 2010 17:15

None

Follow

Field structure is 9999-99-xxx

I need to create a filter thar brings back all unique values that are used in G/L entry

cell1 NL(Filter, G/L Entry, "=MID(""G/l Account No."" ,9,3)", etc)
cell2 NP(join, cell1, "|") brings Value


I've tried "=MID(NF(


I "know" there has to be a way to do this ( after all Jet does everything :roll: )

All help greatly appreciated

• Facebook
• Twitter
• LinkedIn

4 comments

• 0
  
  Jet Reports Historic Posts October 13, 2010 17:59

  Hi vanjump,
  
  I think the formula you're looking for is this:
  
  =NL("Filter","G/L Entry","=MID(NF(,""G/L Account No.""),9,3)",etc)
  
  Does that work for you?
  
  Regards,
  Hughes

• 0
  
  Jet Reports Historic Posts October 14, 2010 21:35

  Brain dead Thanks :lol:

• 0
  
  Jet Reports Historic Posts June 14, 2011 20:28

  OOps just tried this on another report and I get excel is unable to evaluate

• 0
  
  Jet Reports Historic Posts June 15, 2011 17:34

  Paste in the exact formula you are using and I will try to see what is wrong.
  
  Regards,
  Hughes