11 Replies Latest reply: May 11, 2016 11:59 AM by Sunny Talwar RSS

    Month processing issue

    Mitchell Scher


      Good morning,

       

      I am using the following expression as part of Set analysis to derive PT values for a month (it works)

      Sum ({$<MonthExp={$(=Only(MonthExp))}>}PT)

       

      When I try to deribe the prior month's values, I am using the following:

       

      Sum ({$<MonthExp={$(=Only(MonthExp)-1)}>}PT) and instead of getting the previous month , i.e 'Mar' I am getting the value of 3 and not able to derive the prior month's values.

       

       

      Please help.

       

      Thank you