Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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]))
What's this "Period {}"? shouldn't it be "Period="?
You should try figuring out what part of the formula isn't working.
What's this "Period {}"? shouldn't it be "Period="?
You should try figuring out what part of the formula isn't working.