1 Reply Latest reply: Jun 21, 2011 12:10 PM by Daniel Rozental RSS

    firstsortedvalue function

      Hi all,

       

      I have a data set that comprises 2 tables.

       

      The first table is work orders, the second table is labour transactions. The relationship is one to many, linked by a WONUM key field.

       

      I want to show the first labour transaction date for each work order in a straight table. Im trying to use the following function as one of the chart expressions:

       

       

      =firstsortedvalue(LABTRANSDATE,LABTRANSDATE)

       

       

      But it is returning null in all cases except where there is only a single corresponding labour record (i.e where there is a one to one relationship).

       

      Can anyone suggest another way to do this?

       

       

      Thanks