0

How to filter on a code field?

Jet Reports Historic Posts

March 28, 2016 22:11

None

Follow

Hi,
I need to filter on a code field value or length. In words: I need to filter all Numbers (No.) in the Resource table whose value is less than 1000 (or length is less than 4).
All code field No. (Employee ID) can convert to values. The filter is in cell B5.
Something like this:
B2=NL("Rows","Resource","No.","No.","<1000")
B4=NP("Join",$B2:$B3,"|")
B5=LEFT(B4,LEN(B4)-1)
Thanks for your help!

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Jet Reports Historic Posts March 28, 2016 23:32

  Hi,
  I resolved the issue:
  B2=NL("Rows","Resource","No.","No.","=IF(VALUE(NF(,""No.""))<1000,NF(,""No.""),""1"")")
  or
  B2=NL("Rows","Resource","No.","No.","=IF(LEN(NF(,""No.""))<4,NF(,""No.""),""1"")")
  Thanks anyway!