Set Analysis

[#1]

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

[#2 · Accepted solution]

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

[swuehl]

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