1 Reply Latest reply: Jun 1, 2016 7:50 PM by PAUL YEO RSS

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

    PAUL YEO

      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