Expression not working in v9 sr7 and beyond

[#1]

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]))

[danielrozental · Accepted solution]

What's this "Period {}"? shouldn't it be "Period="?

You should try figuring out what part of the formula isn't working.