set analysis expr checking

[#1]

hi,

pls check, not showing data.

sum(

{<Set_ID = {1}>}

IF(GetSelectedCount(QuarterFlag)>0,MonthOpenFlag,Count({<WeekNo={">=$(=Max(WeekNo)-12)<=$(=Max(WeekNo))"}>}WeekOpenFlag)))

Regards,

Sub2u444

[Chanty4u]

any errors?

try

sum(

{<Set_ID = {'1'}>}

IF(GetSelectedCount(QuarterFlag)>0,MonthOpenFlag,Count({<WeekNo={">=$(=Max(WeekNo)-12)<=$(=Max(WeekNo))"}>}WeekOpenFlag)))

[swuehl]

That's because your embedding an aggregation function into another aggregation function, so in general, you would need to use advanced aggregation aggr() function if you want to do this.

But maybe you want to do it like

IF(GetSelectedCount(QuarterFlag)>0,

sum({<Set_ID = {1}>} MonthOpenFlag),

Count({<WeekNo={">=$(=Max(WeekNo)-12)<=$(=Max(WeekNo))"}>}WeekOpenFlag)

)