4 Replies Latest reply: Sep 3, 2010 8:30 AM by Miguel Angel Baeyens de Arce RSS

    Help on SetAnalysis


      HI All,


      I Want to get an Outstanding Amt (Sum(Amt)).I have data which starts from 200901.

      So now for Eg: :when i click 201002 (Feb'2010) i should get sum of outstanding from 2009-01 to 201002.


      I am using the below code its not working


      =num(sum({$<Year = {$(=max(Year))}, Month = {"<=$(=max({<Year={$(=max(Year))}>} Month))"}>} Amt), '#,##0;($#,##0)')

      CAn Any one please help me.


      Thanks in Advance