2 Replies Latest reply: Apr 30, 2013 9:21 AM by Stefan Wühl RSS

    Set Analysis

    gilles sanchez

      When using below Variable, the expression returns a value only if the dimension KEY_FORECAST_WEEK_PROG is selected with a unique value.

      As soon as several values or no value is selected, the chart can not any more display the below variable.

       

      =

      Sum({$<KEY_FORECAST_WEEK_PROG={"<=$(=KEY_CALENDAR_WEEK_PROG)"},KEY_FORECAST_WEEK_PROG={">=$(=KEY_CALENDAR_WEEK_PROG-3)"}>}

       

      NET_BILLING_VAL_D)/UnitConstant

       

      Any help is welcome

       

      Thanks Ahead

       

      Gilles

       

        • Re: Set Analysis
          Vishwaranjan Kumar

          try this

           

          =

          Sum({1<KEY_FORECAST_WEEK_PROG={"<=$(=KEY_CALENDAR_WEEK_PROG)"},KEY_FORECAST_WEEK_PROG={">=$(=KEY_CALENDAR_WEEK_PROG-3)"}>}

           

          NET_BILLING_VAL_D)/UnitConstant

          • Re: Set Analysis
            Stefan Wühl

            In general, you shouldn't use multiple field selection modifier for the same field (KEY_FORECAST_WEEK_PROG) in the same set expression. Instead, use an advanced search expression that combines your sets:

             

            =

            Sum({$<KEY_FORECAST_WEEK_PROG={">=$(=KEY_CALENDAR_WEEK_PROG-3)<=$(=KEY_CALENDAR_WEEK_PROG)"} >}

            NET_BILLING_VAL_D)/UnitConstant