4 Replies Latest reply: Dec 12, 2016 1:28 PM by Jarkko Pelli RSS

    Firstsortedvalue and sum

    Jarkko Pelli



      I have a very simple issue I cant figure out. I have 2 columns, A column with value and B column vith Date. Im using firstsorteddate to get the latest enrty from those 2 columns.


      firstSortedValue(Valuation,-[date([Effective date]])])


      This is working, if the expression only returns one latest date. But when there are 2 latest dates, it does not return anything. How do I sum the valuation when there are multiple entries?


      Thanks for your help!