0

Finding lowest value in a table?

Jet Reports Historic Posts

August 14, 2013 05:21

None

Follow

Hi,

I am trying to create a report that needs to find the lowest invoiced price from the sales invoice line table for approx 2,000 inventory items.

I cant seem to find a way to easily report the lowest value found in the unit price field.

Any suggestions would be most appreciated :-)

Thanks
Sara

• Facebook
• Twitter
• LinkedIn

4 comments

• 0
  
  Jet Reports Historic Posts August 16, 2013 09:48

  Hi Sara,
  
  You could sort your sales invoice line table for each item by price (ascending) and intergate it with an NL(First) formula.
  
  
  Elena

• 0
  
  Jet Reports Historic Posts August 19, 2013 01:13

  Thanks for that Elena, I did try outputting and sorting our sales price table, but we have so many records it makes running the report almost impossible.
  
  I was hoping that there was a magic formula that could lookup the MIN on a table without having to output it all.
  
  Thanks again for your suggestion.
  
  Sara

• 0
  
  Jet Reports Historic Posts August 20, 2013 11:00

  Well, as far as I know, the NL(First) would be tha magic formula to retrieve the MIN that you are looking for.
  I don't know what you have tried but I was thinking about something like this:
  
  C7=NL("First";"Sales Invoice Line";"Unit Price";"Type";"Item";"No.";B7;"+Unit Price";"*")
  
  
  Elena

• 0
  
  Daniel Baker December 02, 2021 13:06

  I'm trying to do the same thing - First returns the first record found matching given criteria, not the minimum value found. This can be done in SQL - but I'm not sure how to type incorporate SQL within a Jet function.