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

    Help on SetAnalysis

    ModiAnkit

      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

      Regards,

      Ankit