0

NL Function - Return unique values

Jet Reports Historic Posts

May 24, 2013 15:23

None

Follow

Hi guys,

Does anyone know how can i exclude duplicate values using the nl function?
For instance, how can i return from value entry NAV table the all my customers without repeating anyone?

Thanks
Jose

• Facebook
• Twitter
• LinkedIn

5 comments

• 
  Jet Reports Historic Posts May 27, 2013 10:35 Official comment

  Try this :
  
  =NL("Rows";"Value Entry";"5 Source No.";"41 Source Type";"Customer")
  In the "Value Entry" table, the "Customer No" is stored in the "Source No." field

• 0
  
  Jet Reports Historic Posts May 30, 2013 12:06

  Hi Tarek,
  
  Thanks for your feedback.
  It doesn´t work, i was trying to use the "allunique" parameter of the nl function but it just returns the firts table value.
  Can i use this?
  
  Thnks
  Jose

• 0
  
  Jet Reports Historic Posts May 30, 2013 15:22

  Hi Jose,
  
  NL(AllUnique) does not do what you think it does, and it is not appropriate for what you are trying to do in this case. NL(AllUnique) is an array operation, which has actually been deprecated in most cases in favor of NL(Filter). Tarek's suggestion actually should do what you are trying to do. Can you attach your report or explain in what way his suggestion is not working?
  
  Regards,
  Hughes

• 0
  
  Jet Reports Historic Posts May 30, 2013 16:37

  Hi Hughes,
  
  Sorry, it works, i was doing something wrong.
  Thanks anyway for your help.
  
  Regards
  Jose

• 0
  
  Tobias Coates August 08, 2023 09:15

  Hi Hughes, 

  is it possible to better explain how to use this functionality in an NL? I am confused by the 5 and 41 included in the fields... 

   

  Best

  Toby