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

    Firstsortedvalue and sum

    Jarkko Pelli

      Hi,

       

      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!