21 Replies Latest reply: May 15, 2012 8:59 AM by chris goudy RSS

    Set analysis expression for current/previous month not working

    chris goudy

      I have this expression, but it doesn't show the max YearMonth Sales if nothing is selected, it shows all sales for the year

       

      sum({$<YearMonth={$(=Max(YearMonth))}, 

      Year, 

      Quarter, 

      YearMonth>}Sales)

       

      Likewise the expression for the Previous YearMonth doesn't work either. It shows the same data as the Max YearMonth

       

      sum({$<YearMonth={$(=Max(YearMonth)-1)}, 

      Year, 

      Quarter, 

      YearMonth>}Sales)

       

       

      Please Help!

      Thank you!!