12 Replies Latest reply: Sep 27, 2017 8:19 AM by Sunny Talwar RSS

    Rangesum issue

    Subathra Barathiventhan

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