14 Replies Latest reply: Mar 11, 2013 1:12 PM by Michael Todd RSS

    Previous Month Expression


      Please can someone help me with calculating the previous month expression.  I have a straight table with number of licenses calculated by:


      sum([Total Licenses])


      Against this I want to show the same value for the previous month, so I written the below expression:


      =sum({$<[Month Key]={$(=[PM Key])}>} [Total Licenses])


      [Month Key] is held on every record to show the month e.g. 3_2012. 

      [PM Key] is also held on every record to show the previous month e.g. 2_2012.


      but not working :-<


      Grateful for any assitance with this.