2 Replies Latest reply: Jul 24, 2013 5:34 AM by Tomer Kalimi

# accumulated calculations problem

I’m having some problem with accumulated calculations

In the table below you can see the outcome of the accumulated calculation by checking the “full accumulation” check box in the expression.

I need the accumulation calculation to be in the other way,

From the bottom to the top.

When I change the sorting, the accumulation calculation is changed, but then I have the latest date at the bottom and I like to have3it on the top.

 C_Date A_Accumulated A 7/23/2013 3,796 3,796 7/22/2013 7,381 3,585 7/21/2013 11,278 3,897 7/20/2013 16,582 5,304 7/19/2013 33,371 16,789 7/18/2013 36,443 3,072 7/17/2013 39,595 3,152 7/16/2013 42,783 3,188 7/15/2013 46,015 3,232 7/14/2013 49,272 3,257 7/13/2013 52,588 3,316 07/12/2013 55,996 3,408 07/11/2013 59,762 3,766 07/10/2013 64,799 5,037 07/09/2013 69,634 4,835 07/08/2013 74,001 4,367 07/07/2013 77,504 3,503 07/06/2013 80,660 3,156 07/05/2013 83,828 3,168 07/04/2013 87,098 3,270 07/03/2013 90,422 3,324 07/02/2013 94,004 3,582 07/01/2013 97,570 3,566

• ###### Re: accumulated calculations problem

try this

Updated By me If You have More than one dimension then

aggr(rangesum(above(sum(Fieldname),0,rowno())),C_Date)

• ###### Re: accumulated calculations problem

nope.

but it helped.

Sum (total A) - rangesum(above(sum(A),0,rowno())))

Somthing like that.

Thanks.