0

Record with the Lastest "Starting Date"

LEE Boon Lai

August 01, 2017 10:46

Answered

Follow

HI I try to get data from Sales Price table. My condition is to get the Unit Price of a particular item from a particular customer with the Latest Starting Date.

How to do this?

 

• Facebook
• Twitter
• LinkedIn

2 comments

• 
  Matthew Wilson August 04, 2017 17:14 Official comment

  Hello Lee Boon Lai,

   

  It sounds as though you may need to make use of the NL(Last) function with sorting applied to it and a filter on the Item No.

  e.g.

  =NL("Last","Sales Price","Unit Price","Item No.",$C4,"+Unit Price","*")

  https://jetsupport.jetreports.com/hc/en-us/articles/218953408

   

  Best regards,

  Matthew Wilson

  Edited by Matthew Wilson August 07, 2017 15:36
• 1
  
  LEE Boon Lai August 07, 2017 11:04

  Hi Matthew, thanks for your reply, it works... thanks a lot.