Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

(RangeSum(Above(RangeSum How to make able list all company ?

Hi All

Below expression from Mr Sunny working fine :-

money(

(RangeSum(Above(RangeSum

(Above(

Sum

(

{

<

year, month, $(ColumnDim801)={$(ColumnDim801)}

>

}

[Amount]/1000), 0, RowNo()))),

-

Sum(

{

<

$(ColumnDim801)={$(ColumnDim801)}>

}

TOTAL Aggr(Sum(

{

<

year, month, $(ColumnDim801)={$(ColumnDim801)}

>

}

[Amount]/1000), YearMonth

))))

, $(vMoneyFormatK))

But when i list all company , the result is wrong for SOURCE =ADL.

Remark :- for TDSS the value alway correct.

Any work around ?

Paul

1 Reply
paulyeo11
Master
Master
Author

my QV Doc