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:






      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?