Hi ,
I Have an expression like below,
= 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)
And i modified 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)
I have charts in Front end with cyclic groups, after modifying the expression the values remains same but the dimension for NULL values are not displaying in the chart. Please help.
Thanks.