Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good afternoon All, I am having an issue with AGGR which I am hoping you will assist with. I need to place a value in a Text Object. The below expression works, but returns the result for every Task_ID. The Task_ID’s are numeric and will always be in sequential order. I only need the Amount for the max Task_ID. =aggr( sum( if(Effective_Date = '2010-01-01 00:00', Amount)), Task_ID ) I need to only sum the Amount for the Max(Task_ID). I am trying the below expression, but is does not return any value. =aggr( sum( max(if(Effective_Date = '2010-01-01 00:00', [Loan Disbursement Amount]), Task_ID)), Task_ID ) Regards, John
Try FirstSortedValue(aggr(sum(Amount),Task_ID), -Task_ID)
Have you tried something like this:
=sum(aggr(max(if(Effective_Date='2010-01-01 00:00',Task_ID)),[Loan Disbursement Amount]))