Whats wrong with this simple AGGR()?

[#1]

Can some one please help me and explain whats wrong with the AGGR statement below. I tried working around this statement changing the functions, but its no use. I have total values at month level and unable to get the running totals using the AGGR(). I just have 4 months data. Its really annoying me for sometime now.

sum(aggr(sum(vLastFctPayment.Amount)-(sum(Expenses.Expenses)-sum(vLastFctPayment.ServicingFee)),Calendar.YearMonth))

I have above expression within a variable called $(vCashToMonth) and I even tried aggr($(vCashToMonth), Calendar.YearMonth) still doesnt work.

Thanks a ton in Advance,

Mady

[#2]

Hello Liron,

Please ignore my previous post, as i figured it out and thanks for all your help. But my original question still remains unaswered as to why the AGGR dint work here?

Can you explain please?

Thanks,

Mady