Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
Is there a way to exclude rows in the rangesum function?
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.
the detailed question is on the following thread:
Best way to be helped in such cases to create a sample qvw. Feeling lazy to create my own.
check attached document please
check attached document on the following link
=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.
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
Try:
=If( RowNo()=1,RangeSum(Above( total Top([Your Result])),b), RangeSum(Above( b,0,RowNo())))
I solved it in the script