column-above(column)

[OmarBenSalem]

Hi all,

here is what I have achieved with the above function

what I want instead is having the sum of all the values above not only the final value.

For example; for Qhour 8:300, I want to return the sum of  23011+8434+4992+742+165, not onlu 23011+8434

How to do so?

Thank you

[Kushal_Chawda]

=rangesum(above(sum(YourField),0,rowno()))

[MayilVahanan]

Hi

Try like this

=Rangesum(Above(Sum(Sales),0, RowNo()))

[MK_QSL · Accepted solution]

RangeSum(Above(YourExpression),0,RowNo()))

or

RangeSum(TOTAL Above(YourExpression),0,RowNo()))

[OmarBenSalem]

Yes, that went all good !

Thank you all