RangeSum of values below

[orital81]

Hello,

I need to Sum all Trans Values of lines bellow to determine the Open Balance

(I know the current and I want to calculate past balances using the accumulated transactions made in previous months)

As seen in the table below, I need to calculate Open Balance in my attached QVW file.

I know I need to use RangeSum and Below functions, but how exactly?

TRANS_YM	Items.Code	Current Balance	Trans Value	Open Balance	Open Balance Calc
2012-07	11007/C/3R	62850.91	-141.23	62992.14	=C2-(D2)'
2012-06	11007/C/3R		-706.15	63698.29	=C2-(D2+D3)'
2012-03	11007/C/3R		0	63698.29	=C2-(D2+D3+D4)'

Please assist,

Thanks

Ori

[#2]

Hello Ori

I started trying a new expression but your's was actually fine, what you needed to do is select full accumulation for the expression.
I attach my version with 2 options for the expressions just in case it helps for another time
Regards,

[orital81]

Hey Pablo

This is realy wierd... It didn't work in my version with the same expression.

But now it works, no explenation. Anyway, thanks for your help.

The correct expression is:

Column(1)-rangesum(Below(Column(2),0,RowNo()))

[#4]

Please check if in your version you have this checked for your open balance expression.
I think that was why yours was not working
Hope it helps!