Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Is there anyway to do this calculation without using aggr function
Sum({$<FiscalYear={"$(=Year(Max(FiscalYear)))"}>}
Aggr(RangeSum(Above(Sum({$<EntryDate={"<=$(=max(EntryDate))"}>}ClosingBalanceAmount),0,RowNo())),Date))
If this is in a table, you might be able to use total function = 'Sum'
k sunny...i will look into that...thanku so much
Sounds good... please close this thread by marking correct and helpful responses if and when you get what you were looking for.
Best,
Sunny