topic Re: SET ANALYSIS COMPLEX in App Development

SET ANALYSIS COMPLEX

Billy_u — Sat, 16 Nov 2024 01:18:41 GMT

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

Re: SET ANALYSIS COMPLEX

Nicole-Smith — Mon, 12 Oct 2020 17:24:50 GMT

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

Re: SET ANALYSIS COMPLEX

Billy_u — Thu, 15 Oct 2020 15:07:35 GMT

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