1 Reply Latest reply: Dec 15, 2011 3:37 AM by Perumal Ayyappan RSS

    Dynamic MTD Calculation

      Hi ,

       

      I trying to calculate dynamic MTD  in stright table , I used below set anlysis to claculate this,

       

      num(sum({$<Year = {$(=max(Year))}, Month = {"<=$(=max({<Year={$(=max(Year))}>} Month))>$(=max({<Year={$(=max(Year))}>} Month)-1)"}>} [In profit center local currency_KSL]), '$#,##0;($#,##0)')

      .

      but this give out "0" if there are no values for the perticular document perticular for that month, I want only to on current month documetnt to be considered.Can any one help me on this ?

       

       

       

      QV.png