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.