accumulated calculations problem

Wed, 24 Jul 2013 09:13:42 GMT

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.

Thanks in advance.

Re: accumulated calculations problem

er_mohit — Wed, 24 Jul 2013 09:18:00 GMT

try this

Updated By me If You have More than one dimension then

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

Wed, 24 Jul 2013 09:25:45 GMT

nope.

but it helped.

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

Somthing like that.

Thanks.