Rangesum and above issue

Sun, 02 Oct 2016 07:00:09 GMT

Hi All,

I have below data set

I am creating straight table

Dimension - ID

Expression = rangesum(above( sum(Amount),0,RowNo()))

Above expression works well for single dimension, but as soon as I am adding another dimension i.e Type, values are changing.

I want the same values when I add any other dimension

Re: Rangesum and above issue

Kushal_Chawda — Sun, 02 Oct 2016 07:05:13 GMT

try this

=rangesum(above(total sum(Amount),0,RowNo(TOTAL)))