5 Replies Latest reply: Jun 28, 2014 5:17 AM by Niklas Krysander RSS

    Issue with previous month set analysis

    Niklas Krysander

      Hi,

       

      I have an issue with getting a previous month set analysis formula. Have been reading the different topics on this without success.

       

      I wish to build a dynamic previous date function that will receive a value from the previous month. If the user chose period 201403, the value for 201402 should appear.

       

      Period is YYYYMM format. I get the previous month by using: Date#(Period, 'YYYYMM')-1

       

      However, I'm not able to get any values on the previous month, I'm using this set analysis:

       

      =sum({$<Period = {"$(=Date#(Period,'YYYYMM')-1)"}>} Amount)

       

      Thankful for any input on how to get this correct.

       

      /Niklas