excluding rows in rangesum

[ali_hijazi]

Hello

Is there a way to exclude rows in the rangesum function?

[tresesco]

No such parameter to pass in rangesum(). But, may be an alternate way could help. Create a qvw with sample data and explain the expected output there.

[ali_hijazi]

the detailed question is on the following thread:

range sum question

[tresesco]

Best way to be helped in such cases to create a sample qvw. Feeling lazy to create my own.

[ali_hijazi]

check attached document please

[ali_hijazi]

check attached document on the following link

excluding rows in rangesum

[tresesco]

=If( RowNo()=1,Above( total Top(b))+b, RangeSum(Above( b,0,RowNo())))

PFA

Hope this is what you wanted. Even I am happy to get the solution the way I got (Intially for a second it came in mind that, 'it might not be possible', but then...!!) . Thanks, for the requirement.

[ali_hijazi]

no it's not correct

I tried solving it by script and used the previous function in the load statement after sorting by release and fix period

the result on period 3 should be 184 and not 163 as your solution

[tresesco]

Try:

=If( RowNo()=1,RangeSum(Above( total Top([Your Result])),b), RangeSum(Above( b,0,RowNo())))

[ali_hijazi]

I solved it in the script