1 Reply Latest reply: Mar 28, 2016 1:24 AM by PAUL YEO RSS

    WHY CHART 2 ONLY WRONG FOR nET_PROFIT ?

    PAUL YEO

      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