1 Reply Latest reply: Aug 1, 2011 2:42 PM by Daniel Rozental RSS

    Expression not working in v9 sr7 and beyond

      Hello,

       

      Has anyone encountered this?

       

      The following expression works in v9 sr6 not in v9 sr7 through v10.

       

      Thanks

       

       

       

      If (MAX(Year) = Year(Today()),

      (sum({$<FlagCurYTD = {1}>}  [Sales Amount])

      -

      sum({$<FlagLastYTD = {1}>}  [Sales Amount]))

      /

      sum({$<FlagLastYTD = {1}>}  [Sales Amount]),

      (sum({$<Year = {$(=max(Year))}, Period {}>}  [Sales Amount])

      -

      sum({$<Year = {$(=max(Year)-1)}, Period {}>}  [Sales Amount]))

      /

      sum({$<Year = {$(=max(Year)-1)}, Period {}>}  [Sales Amount]))