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,