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

    [FirstsortedValue] Multiple row, same date



      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 ?