Wie kann ich in einer Formel akkumulieren?

[robert_gansel]

Hi Community,

I am experiencing a problem with my formula regarding accumulation (see formula below):

sum(aggr(Rangesum(above(sum({<Status={'IST'}, KN_Bereich_HK={'Invest'}, KN_Bereich_UK1 = {'Ankaufkosten'}, KN_Bereich_UK2 = {'Kaufpreis Objekt'}>} Betrag),0 ,RowNo())), Jahr_Wertstellungsdatum))

It is my target to accumulate all figures over years. In general it works but as soon as there comes a year with value "0" (see example below):

2010 --> 1,000,000 --> akkum. = 1,000,000

2011 --> 1,500,000 --> akkum. = 2,500,000

2012 --> 0 --> akkum. = 0 (but it should stay 2,500,000).

Is there anyone who can help with this issue?

Thanks in advance.

Best regards

Robert

[marcus_sommer]

Try it without the aggr().

- Marcus

[robert_gansel]

Thanks for the answer. I already tried this - but in this case it is showing nothing.

[marcus_sommer]

Nothing looked that there is somewhere an (syntax) error - sometimes you need a TOTAL within the rowno() for  correct results but even without them you will get results.

Please provide more informations - how the object incl. dimensions and expressions looked like and a sample-application would be helpful, too.

- Marcus