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

    Month processing issue

      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