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