2 Replies Latest reply: Jul 4, 2012 4:17 AM by Raghavendra Suryakumar RSS

    Balance Sheet Help!

      Hi all,

       

      I have a formula which grabs all the previous years entries, in order to develop a balance sheet. The formula is as follows:

       

      =if([Account Type]='Balance Sheet',sum({1<Year={$(vMaxYear)},Date={'<=$(vMaxDate)'},Month=>}(Amount)))

       

      The Formula grabs everything as at today. However, what I want is to grab the entries up to the month/year that the user selects.

       

      How would I go about this?

       

      Many thanks,