1 Reply Latest reply: Jul 9, 2012 12:00 PM by Kiran Rokkam RSS

    FirstSortedValue in a Straight Table

      Hi

       

      I am trying to get the First line of data in the following Table

       

      Claim NumberClaim Done DateSum([Claimant Reserve Payment])FirstSortedValue(Sum([Claimant Reserve Payment]), [Claim Done Date])
      AE00082703/07/2012

      9108.2

      -

      AE000827

      04/07/201216358.2-
      AE00082705/07/201210042.2-
      AE00082706/07/201210042.2-
      AE00082709/07/201210042.2-

       

      What I was hoping for was the table just to show the first line so I know what the reserve was on the earliest date.  As you can see my expression using firstsortedvalue is just returning nulls

       

      Can anyone help Please

       

      Regards

       

      Matt