Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
use
rangesum(above(
your Expression
,0,rowno()))
Regards
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
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