Rangesum issue

[subathra]

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))

[sunny_talwar]

If this is in a table, you might be able to use total function = 'Sum'

[subathra]

k sunny...i will look into that...thanku so much

[sunny_talwar]

Sounds good... please close this thread by marking correct and helpful responses if and when you get what you were looking for.

Best,

Sunny