Range sum function in expression

[aniruddhyadutta]

Hi All,

I have an expression which is working fine to calculate the cumulative and non cumlative sum of a measure as below

if (SELECTOR1='CUM',

RangeSum(Above(Sum(Documents_Produced), 0,  RowNo())),Sum(Documents_Produced))

Now I just changed the expression to take distinct proc ids while evaluating the document produced which is not working

if (SELECTOR1='CUM',

RangeSum(Above(sum(Count({$<Documents_Produced={'1'}>} distinct PROC_ID), 0,  RowNo())

  Sum(Count({$<DATE={'$(vDATE)'},Documents_Produced={'1'}>} distinct  PROC_ID)))

can some one plz help?

[agigliotti]

you can't do sum of count...

change from:

sum(Count({$<Documents_Produced={'1'}>} distinct PROC_ID) )

to:

Count({$<Documents_Produced={'1'}>} distinct PROC_ID)

OR

Sum( Aggr( if( SELECTOR1 = 'CUM',

RangeSum(Above( Count({$<Documents_Produced={'1'}>} distinct PROC_ID), 0,  RowNo() ) ),

Count({$<DATE={'$(vDATE)'},Documents_Produced={'1'}>} distinct  PROC_ID ) ), PROC_ID ) )

[swuehl]

In general, you need advanced aggregation aggr() function to embed an aggregation function like Count() into another aggregation like Sum().

[aniruddhyadutta]

Thanks Andrea! it worked..

[aniruddhyadutta]

Thanks for the suggestion Stefan..as of now my expression is working as suggested by Andrea..but its a take way for me which I will need for sure..