8 Replies Latest reply: Mar 31, 2014 9:25 AM by Kevin Rabe RSS

    [FirstsortedValue] Multiple row, same date

      Hi,

       

      I'm currently working on a graph that will show the score of customer. It's just a field, link with some date. The users want to see the last value available, so i'm using

       

      =FirstSortedValue(CUST_SCORE, -Date)

       

      It works but the problem is, sometimes, there is multiple row with the same date (and same score) so it shows "-".

       

      I tried ONLY() but the expression didn't work at all... Do you have an idea ?