Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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