SET ANALYSIS COMPLEX

[Billy_u]

I have to do this calculation, it tells me that the formula is syntactically ok, but really the analysis set does not work? what am I wrong?

=if(GetSelectedCount (MONTH)=12 or GetSelectedCount (MONTH)=0,

sum({<YEAR = {$(=max(YEAR))},CODE={"1*"}>}SALES),
if(sum({<YEAR = {$(=max(YEAR)-1)},CODE={"1*"}>}SALES)>0,

[sum({<YEAR = {$(=max(YEAR)-1)},CODE={"1*"}>}SALES)

*sum({<YEAR = {$(=max(YEAR))},CODE={"1*"}>}SALES)

/sum({<YEAR = {$(=max(YEAR)-1)},CODE={"1*"}>}SALES)],

sum({<YEAR = {$(=max(YEAR))},CODE={"1*"}>}SALES)]/Count(DISTINCT {<YEAR = {$(=max(YEAR))} >} MONTH)*12))

[Nicole-Smith · Accepted solution]

It's not going to work with the square brackets you have in the expression (and I'm not sure why they are there to begin with):

=if(GetSelectedCount (MONTH)=12 or GetSelectedCount (MONTH)=0,
sum({<YEAR = {$(=max(YEAR))},CODE={"1*"}>}SALES),
if(sum({<YEAR = {$(=max(YEAR)-1)},CODE={"1*"}>}SALES)>0,
[sum({<YEAR = {$(=max(YEAR)-1)},CODE={"1*"}>}SALES)
*sum({<YEAR = {$(=max(YEAR))},CODE={"1*"}>}SALES)
/sum({<YEAR = {$(=max(YEAR)-1)},CODE={"1*"}>}SALES)],
sum({<YEAR = {$(=max(YEAR))},CODE={"1*"}>}SALES)]/Count(DISTINCT {<YEAR = {$(=max(YEAR))} >} MONTH)*12))

[Billy_u]

oops, I must have really crossed my eyes, thank you very much...