Cumulative calculation from 3rd day

[nareshthavidishetty]

Hi,

We were using the below logic to get the cumulative total.

Logic: rangesum(above(total sum(Product$TY), 0, rowno(Total)))

But we need to calculate the cumulative total from 3rd row.

Thanks..

[sujeetsingh]

So this expression is used in straight table. You can use rank() there and just write a if condition that if rank is 3 then rangesum(above(total sum(Product$TY), 0, rowno(Total)))

[nareshthavidishetty]

Hi,

Can you please provide the complete logic,because when i include the rank in the logic it gives error.

Thanks..

[MayilVahanan]

Hi

Are you looking like this

rangesum(above(total sum(Amount), 0, rowno(Total)-2))

[tamilarasu]

Hi,

Try this,

Rangesum(Above(total If(Rowno(Total)>2, sum(Product$TY)), 0, Rowno(Total)))

[nareshthavidishetty]

Hi,

We need to accumulate the data as below..

31st would remain same..1st would remain same and from 2nd it should accumulate with 1st and so on..

Thanks..

[MayilVahanan]

Hi

Try like this

RangeMax(If(Rowno(Total)> 2, rangesum(above(total sum(Amount), 0, rowno(Total)-1)), 0), Sum(Amount))

[nareshthavidishetty]

Thanks Mayil..

The same if we need to do it for %..and we use the below logic..but it simply adds the sum like 1st the % is 10.5% on 2nd its 90.5% but here the cumulative gives 101% which is not correct..we need the avg %

Below is the logic used:

RangeMax(If(Rowno(Total)> 2, rangesum(above(total ((Sum(Product$TY))/Sum(Product$LY)), 0, rowno(Total)-1)), 0), ((Sum(Product$TY))/Sum(Product$LY)))

Thanks...

[MayilVahanan · Accepted solution]

Hi

Instead of RangeSum, try with RangeAvg() function.

Hope it helps