Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Maybe like
=Sum({<Year = {2014}>} Aggr(FirstSortedValue({<Year = {2014}>} [Loan($)],-Date),[Grower No.]))