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

    Previous Month Expression

    Michael Todd

      Hi,

      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.

       

      Mike.