0 Replies Latest reply: Jan 28, 2015 3:42 AM by Uma Shankar Kosaraju RSS

    Previous month Sales calculation

      Hi All,


      I have a doubt in set analysis for calculating sum of previous month sales. The calculation is based on 5 columns


      The expression i wrote in calculation is:


      SET Shared.Calculation.SOHValueMonth='SUM({<[FISCAL YEAR]={$1},[FISCAL MONTH]={$2}>} [A]+[B]-[C]+[D]+[E])';


      and calling this calculation in expression as:


      =NUM($(Shared.Calculation.SOHValueMonth($(=[FISCAL YEAR]),$(Shared.Calculation.CurrentFiscalMonth)-1)), Shared.Format.MoneyRound)


      Please let me know if my approach is right.... Thanks in advance.