Accumulated Sum - Straight Table

[pamaxeed]

Hi all,

I need help with the above function.

I have following straight table:

The relevant column ist TWR YTD, which should reflect the accumulated SUM from TWR Täglich.

The logic should be adjusted here with following requirements

1. Acc Sum by ID and ISIN
2. If Flag IstBeginn = 1 we should start to sum up from 0

In this case the red underlined values should be all 0 as we do not have any specific value in TWR Täglich column.

I used the following function:

• Rangesum( above(total Column(6),0,rowno(total)))

We have to tweak with the last 2 parameters and maybe use the AGGR function by grouping the resultset by ID and ISIN (not sure if needed).

Is there anyone who can support me here?

Thanks,

Patric

[sunny_talwar · Accepted solution]

Have you tried this?

RangeSum(Above(Column(6), 0, RowNo()))

[sunny_talwar]

You might have to create a new field in the script like this

LOAD Id*ISIN as Key

and then try like this

Aggr(RangeSum(Above(Column(6), 0, RowNo())), Ket, DateField)

[pamaxeed]

Looks good!

Can you explain me what is the difference to mine one?

Thanks!

[sunny_talwar]

By design when you add TOTAL to Above and RowNo, they accumulative regardless of the chart dimension... where as without TOTAL, the value changes based on dimension change.