Hi ,
I have an expression like this,
= SUM({
$<
ACCT_MO = P({$}MO),
ACCT_WK_IN_YR = P({$}WK_IN_YR),
ACCT_YR = {$(=only(YR))},
MO_NM_ABBR =
>}NET_LBS_SHIPPED)
/
SUM({
$<
SLR_PCT_RANGE = ,
ACCT_MO = P({$}MO),
ACCT_WK_IN_YR = P({$}WK_IN_YR),
ACCT_YR = {$(=only(YR))},
MO_NM_ABBR =
>}
TOTAL <$(eCycleGroup)> NET_LBS_SHIPPED)
I modified my expression to,
= SUM({
$<
ACCT_MO = P({$}ACCT_MO),
ACCT_WK_IN_YR = P({$}ACCT_WK_IN_YR),
ACCT_YR = {$(=only(ACCT_YR))},
ACCT_MO_NM_ABBR =
>}NET_LBS_SHIPPED)
/
SUM({
$<
SLR_PCT_RANGE = ,
ACCT_MO = P({$}ACCT_MO),
ACCT_WK_IN_YR = P({$}ACCT_WK_IN_YR),
ACCT_YR = {$(=only(ACCT_YR))},
ACCT_MO_NM_ABBR =
>}
TOTAL <$(eCycleGroup)> NET_LBS_SHIPPED)
After modifying the expression, in the front end chart i have a cyclic group. The values which are NULL are not displaying with Dimensions.