Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try it without the aggr().
- Marcus
Thanks for the answer. I already tried this - but in this case it is showing nothing.
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