8 Replies Latest reply: Jun 2, 2016 3:33 AM by PAUL YEO RSS

    How to get Last year same period Stock Amount ?

    PAUL YEO

      Hi All

       

      May i know how to change the below SET expression , to get Last year same period Stock Amount ?


      Money(RangeSum(
      Above(RangeSum(Above(Sum({<year, month, GL_CODE = {50010}>}[Amount]*1), 0, RowNo()))),
      -Sum({<GL_CODE = {50010}>}TOTAL Aggr(Sum({<year, month, GL_CODE = {50010}>}[Amount]*1), YearMonth)))
      , $(vMoneyFormatK_GL))

       

      So that my Table 2 have  one more column display LY same period stock amount.

       

      Paul