1 Reply Latest reply: Apr 29, 2014 1:50 PM by Stefan Wühl RSS

    Conditional aggregate

      Hi All,

       

      I have the following expression which works fine: "=Sum(Aggr(FirstSortedValue([Loan($)],-Date),[Grower No.])) ". In my data, I have a column with "Year" in it. How can I tweak the expression so that it only sums up where Year = 2014 for example. I am getting myself in a twist trying to use the if function here.

       

      Thank you

       

      Herbert