Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
any errors?
try
sum(
{<Set_ID = {'1'}>}
IF(GetSelectedCount(QuarterFlag)>0,MonthOpenFlag,Count({<WeekNo={">=$(=Max(WeekNo)-12)<=$(=Max(WeekNo))"}>}WeekOpenFlag)))
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)
)