Cumulative Numbers

[dries_clairhout]

Good day,

I have this formula in a LineGraphic

if(sum(Debet) > sum(Credit), sum(Credit) - sum(Debet)) &' '& if(sum(Credit) > sum(Debet), sum(Credit) - sum(Debet))

But I would need to cumulative show the numbers per month.

Now it is the amount per month,

But it should be the previous month + the current month. so in December I would have te year amount.

Any help?

Thanks a lot!

[martinpohl · Accepted solution]

use

rangesum(above(

your Expression

,0,rowno()))

Regards

[dries_clairhout]

Hello,

I know this will work,

but how do i get this graphic?

Zo "vaste Kosten" is a dimension

Year is a Line,

my expression is the measure,

but what abut month?

And I only see line and measure in the options.

Any help on this? 

thanks a bunch

[jyothish8807]

Hi Dries,

Try this:

rangesum(above(if(sum(Debet) > sum(Credit), sum(Credit) - sum(Debet)),0,rowno()) &' '&

rangesum(above(if(sum(Credit) > sum(Debet), sum(Credit) - sum(Debet)),0,rowno())

Br,

KC