4 Replies Latest reply: Oct 3, 2017 5:52 AM by Aniruddhya Dutta

# Range sum function in expression

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?

• ###### Re: Range sum function in expression

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 ) )

• ###### Re: Range sum function in expression

Thanks Andrea! it worked..

• ###### Re: Range sum function in expression

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

• ###### Re: Range sum function in expression

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..