Accumulation Not working for Calculating other columns
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.
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