2 Replies Latest reply: Apr 16, 2016 6:11 AM by Stefan Wühl RSS

    set analysis expr checking

    Subba Reddy

      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

        • Re: set analysis expr checking
          Chanty 4u

          any errors?

          try

           

          sum(

          {<Set_ID = {'1'}>}

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

          • Re: set analysis expr checking
            Stefan Wühl

            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)

            )