Accumulation Not working for Calculating other columns

[maahivee]

Hello Guys - I have a simple requirement here, But for some reason it is not working..

In a straight table, i have columns  added picks, completed picks, which are regular calculations based on data from tables.

After that i have Begin, added picks cumulative and completed picks cumulative which are same calculations as above but i am giving "full accumulation" for these 3 columns.

And then i have # of Picks which is basically "begin + added picks cumulative - completed picks cumulative".

So when i am doing this # of picks column calculation based on the Full Accumulation columns, I would assume it showing results based on Full accumulation value for that row instead showing result based on the actual value..

Is there any thing i am missing here. or doing anything wrong. Please see the attached sheet for more data.

[Clever_Anjos]

When you use the regular accumulation feature, that is the regular behaviour.

You need to use the Rangesum(Above(yourexpression),0.rowno())) in order to obtain your accumulation value

Please read this explanation: Range Sum

[sunny_talwar]

I think you would probably need to use RangeSum(Above(...)) instead of Full Accumulation to make this to work. I can't comment more because I don't have the expression or a sample, but this should guide you in the right direction. If you still have trouble, I would suggest providing a sample with your expected output

[maahivee]

Rangesum(Above("Begin"-"Completed Picks Cummulative"+"Added Picks Cummulative"),rowno(),0)

I have tried this but giving 1 as result for all rows.

[sunny_talwar]

Again I am not 100% sure, but may be this:

RangeSum(Above("Begin"-"Completed Picks Cummulative"+"Added Picks Cummulative", 0, RowNo()))

[maahivee]

Hello Sunny - PFA.. Column D (Desired Result) Column is the answer i am looking for.

Hour	Begin	# of Picks	Desired Result	Added Picks	Added Picks Cummulative	Completed Picks	Completed Picks Cummulative
	101	331		203	203	128	128
5	101	0	101	0	0	0	0
7	101	19	120	19	19	0	0
8	101	190	110	90	109	100	100
9	101	122	176	94	203	28	128

[Clever_Anjos]

What are the expressions for "Begin" and other fields?

[maahivee]

This is again giving the same result as not using the accumulation column.

[maahivee]

=Count({<StatusType={'Begin'}>}TransactionAmt) for Begin

=Count({<StatusType={'Added'}>}TransactionAmt) for added

=Count({<StatusType={'Completed'}>}TransactionAmt) for completed

Same expression but giving "full accumulation" for cumulative columns.

[sunny_talwar]

What is the expression for # of Picks?