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