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

    Issue with previous month set analysis



      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.