1 Reply Latest reply: Mar 28, 2016 1:24 AM by Yeo Poh sai

# WHY CHART 2 ONLY WRONG FOR nET_PROFIT ?

Hi All

I have a very funny encounter. when click on step 1 dimension = nET_PROFIT , Below expression use by chart 2 is wrong :-

Sum(DISTINCT{<year = {"\$(=Max(year)-0)"},\$(ColumnDim601) ={\$(ColumnDim601)}>} Amount*-1/ \$(Columndim89)/1000),

After i change the expression to below , it work fine , see Chart 1:-

SUM({<year = {"\$(=Max(year)-0)"},month={"<=\$(=Max({<sales = {'*'}, year = {\$(=Max(year))}>}month))"},nET_PROFIT={nET_PROFIT}>}Amount*1)/\$(Columndim89)/1000,

Now when Click on Step 2. for rEVENUE , my chart 2 expression as below  :-

Sum(DISTINCT{<year = {"\$(=Max(year)-0)"},\$(ColumnDim601) ={\$(ColumnDim601)}>} Amount*1/ \$(Columndim89)/1000),

it return correct value. for both chart 1 and 2. ( show the same value , meaning is correct )

My Question is why i don't need to change the expression to below at chart 2 , during eEVENUE :-

After i change the expression to below , it work fine :-

SUM({<year = {"\$(=Max(year)-0)"},month={"<=\$(=Max({<sales = {'*'}, year = {\$(=Max(year))}>}month))"},rEVENUE={rEVENUE}>}Amount*1)/\$(Columndim89)/1000,

yet i am using below expression , yet is working fine :-

Sum(DISTINCT{<year = {"\$(=Max(year)-0)"},\$(ColumnDim601) ={\$(ColumnDim601)}>} Amount*1/ \$(Columndim89)/1000),

Can some one share with me why ?

Paul