Hi Bruno, thank you for you response. I have tried your expression, but I am receiving this error... Error in expression: Aggr takes at least 2 parameters
This is what I have tried:
Your chart is exactly what I need, but I am unable to replicate it. Could you perhaps attach the file for me?
I have manage to add the expression, but now it only shows zero's...
rangesum( aggr( rangesum(below( sum(AmtCollected), 0, rowno() )), Day, MONTH ))
Thank you kindly
I think you will need to create Month and Day in your script so that you can use them in Aggr() function:
Month(DB_Date) as MONTH,
Day(DB_Date) as Day
and then try this as your expression:
RangeSum(Aggr(RangeSum(Below(Sum(AmtCollected), 0, RowNo() )), Day, MONTH))
Another important this to ensure here to to sort the DB_Date correctly in order to get correct accumulation here. If the date isn't sorted in the script, you might run into errors.
Hello Guys... I hate to be nuisance, and appreciate all the replies so far.
This is what I have done so far...
1. Ordered the date in the select statement
2. Entered "RangeSum(Above(Total Sum(AmtCollected),0,RowNo(Total)),MONTHOF,DAYOF)"
3. Getting the following Graph output:
4. The January line started at about 180 000 and ended at an accumulated amount of 5 000 000. The December line started at 1 200 000 and accumulated to +- 21 000 000. this means that the two lines should have parted a lot..
See Excel example:
Thanks again for all your help so far
I have added the following to my select statement:
Order by day(db_date) Asc
Once loaded with the previous expression:
I finally got the desired result
Thank you very much for all your help guys... it is working so far.!